- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] I want to delete specific characters included in data using DataSpider
Search via FAQ No.
NEW
[DataSpider Servista] I want to delete specific characters included in data using DataSpider
Because specific characters are included in the character data, it cannot be inserted into a database after reading the data by Read CSV File. Since they become invalid characters in the database, how do I delete the following specific characters?
What is a specific character? Result confirmed by a binary editor
1C
- Category :
Answer
By reading data with the Read CSV File and using the Mapper's Replace by Regular Expression logic, it is possible to remove "1C" contained in the data.
String before replacement (regular expression pattern): \x1c
String after replacement:
* The String after replacement is omitted (empty character).
For more details on the Replace by Regular Expression logic, please refer to the following DataSpider Help.
- [Mapper]-[Mapper Logic Guide]-[String]-[Replace by Regular Expression]
URL：https://www.hulft.com/help/en-us/DataSpider/dss42sp2/help/en/mapper/document/logic/replace.html
- Version Information
- Ver.4.1、Ver.4.0、Ver.3.2