Example of using the REPLACE_REG function

1. Replacing the first あ character string with い, and replacing the other あ character strings with う

Figure A.67 Example of using the REPLACE_REG function with regular expressions (1)

2. Removing spaces from the end

Figure A.68 Example of using the REPLACE_REG function with regular expressions (2)

3. Placing the first number set between square brackets ([ and ])

Figure A.69 Example of using the REPLACE_REG function with regular expressions (3)

4. Change all サーバ to サーバー so that there is no mixture of サーバ and サーバー in the character strings

Figure A.70 Example of using the REPLACE_REG function with regular expressions (4)

5. Acquiring the middle value of a set of numbers (first number having 1 to 3 digits and last number having 1 to 3 digits) separated by hyphens (-)

Figure A.71 Example of using the REPLACE_REG function with regular expressions (5)

6. Replacing null with character string NULL

Figure A.72 Example of using the REPLACE_REG function with regular expressions (6)

7. Adding a zero before the month and day in a yyyy/mm/dd format date data

Figure A.73 Example of using the REPLACE_REG function with regular expressions (7)

8. Extracting only the file name from the full path

Figure A.74 Example of using the REPLACE_REG function with regular expressions (8)

9. Adding double quotation marks (") in front of and after input data (does not add an extra double quotation mark when a double quotation mark already exists)

Figure A.75 Example of using the REPLACE_REG function with regular expressions (9)

10. Moving the sign to the front when the last character is a sign in an 8-byte numeric character string

Figure A.76 Example of using the REPLACE_REG function with regular expressions (10)

11. Trimming the leading zero or zeros in front of integers (signs are kept and only the zeros are trimmed)

Figure A.77 Example of using the REPLACE_REG function with regular expressions (11)

12. Trimming the leading zero or zeros in front of decimals (signs are kept and only the zeros are trimmed)

Figure A.78 Example of using the REPLACE_REG function with regular expressions (12)

13. Converting hexadecimal character strings with the specified zone data (zone position F, Pos. C, Neg. D) to numeric values

Figure A.79 Example of using the REPLACE_REG function with regular expressions (13)

14. Acquiring character strings remaining after the matching characters in the two character strings before and after the halfwidth space are eliminated.
Different item data is combined into a variable in order to compare characters from the front and acquire the character string that consists of characters that do not match.

Figure A.80 Example of using the REPLACE_REG function with regular expressions (14)