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.
URL:https://www.hulft.com/help/en-us/DataSpider/dss42sp2/help/en/mapper/document/logic/replace.html