Question
What logic or method should I use to replace a newline code (e.g. CRLF) with another newline code (e.g. LF) or a specific string, or a specific string with a newline code?
Answer
You can replace a newline code with another newline code or a specific string by using the Replace by DB Table or by CSV Table logics.
For more information on each logic, please refer to the links in the Reference Information section.
Prepare a database table or CSV file with two columns each with a newline code/specific string for the replacement target and the replacement after, and specify the table or CSV file prepared with the corresponding logic.
Example
To replace the string "newline" to a newline code in a CSV file, prepare a CSV file like the following:
newline,"
"
Reference Information
Replace by DB Table - HULFT Square Documentation
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/ConvertByDB.htm
Replace by CSV Table - HULFT Square Documentation
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/ConvertByFile.htm
There is also a method of replacement using Replace by Regular Expression logic. Please refer to the FAQ below for details.
How do I replace a newline code in a string with another string?
https://support.square.hulft.com/hc/articles/9465818157204
Comments
0 comments
Article is closed for comments.