I want to delete specific characters contained in data by using HULFT Square

Question

I am unable to insert data into a database after reading the data with the Read CSV File operation because there are certain characters in the character data (it is "1C", as confirmed by a binary editor).
What should I do to remove the specific characters because they will be invalid in the database?

Answer

You can remove "1C" from the data by reading the data by Read CSV File operation and using Mapper's Replace by Regular Expression logic.

How to Specify

・String before replacement (regular expression pattern): \x1c
・String after replacement:

　*The string after replacement is omitted (empty string).

For more information on the logic, please refer to the following page.

Replace by Regular Expression
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/Replace.htm