- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] I want to replace the line feed code with a different line feed code or a specific string.
Search via FAQ No.
NEW
[DataSpider Servista] I want to replace the line feed code with a different line feed code or a specific string.
For example, a line feed code (e.g.: CRLF) to a different line feed code (e.g.: LF) or a specific string. In addition, I want to replace the new line code for a particular string.
What kind of logic or method should I replace?
- Category :
Answer
By using DB table replacement logic or CSV file replacement logic, you can replace the line feed code with a different line feed code or a specific string.
*For more information on the each logic, please refer to the link reference information.
Please prepare a database table or a CSV file in which two columns are set with the line feed code to be replaced, the line feed code after replacement, a specific character string, the string to be replaced and the line feed code after replacement. After all preparations, you need to specify the table or CSV file prepared by the corresponding logic.
■Example
If you want to convert the characters "line feed" to line feed code in the CSV file, you need to prepare the following CSV file.
Line Feed,"
"
Reference Information
・Replacement logic by DB table
・Replacement logic by CSV file
https://www.hulft.com/help/en-us/DataSpider/dss42sp2/help/en/mapper/document/logic/convertByFile.html
・ There is also a way to convert using regular expression substitution logic. Please refer to FAQ No. 24386 for details.