• Font Size
  • S
  • M
  • L

Search via FAQ No.


  • No : 24386
  • Open Date : 2016/06/13 14:16
  • Print

[DataSpider Servista] How to replace the line feed code to another string in the Mapping process?

How to replace the line feed code included in the string to another string in the Mapping process?
 
Category : 

Answer

The line feed code included in the string can be replaced to another string in the Mapping process by using the following logic icons.
 
Use the [Replace by Regular Expression] logic icon available in [Conversion] of [String] category.
 
In the [String before replacement (regular expression pattern)] property of Replace by Regular Expression logic icon, specify the line feed code of the input string in the regular expression.
 
In [String after replacement] property, when matching to regular expression of the specified line code, specify the string to be replaced.
 
The regular expression of the line code specified in [String before replacement (regular expression pattern)] property is as given below.

 
Line feed code | Regular Expression
---------------------
CR | \r
LF | \n
CRLF | \r\n