remove LF line feeder

[muthu7]

Hi All,

We are trying to egress tables from Sybase , few tables columns contains LF(line feeder) , Due this new rows been ingested / created at destination tables due to LF. Please let me know how LF can be removed.

Thx

[john_wang]

Hello @muthu7 

Check this article Remove Carriage Returns ,

hope this helps.

Regards,

John.

[Heinvandenheuvel · Accepted solution]

What is the target DB (endpoint)?  Many if not most targets support  the 'advanced' internal parameter : replaceChars

Sample settings are  "0x0D,0x20,0x0A,0x20"  (CR to space, LF to space) and "0x0D,0x" (CR to nul) and many more.

The following text originally circulated within Attunity best I know. Google found it back and I shamelessly copied it from: https://attunity46.rssing.com/chan-63610596/all_p1.html

If the issue is limited to a few columns/tables, then you may  prefer to use a per column transformation using functions like replaceChars(X,Y,Z) and replace. Search for that in the Replicate User Guide.

hth, Hein.

------

1. In order to replace all non-ASCII characters , you need to set your ReplaceChars string, in the following format:
ReplaceChars=T,n (where n = 0 , 1, or 2):


n=0 means: all characters will be replaced to a "?" , besides the characters between 0x20 to 0x7E and the characters TAB, CR, LF
n=1 means: all characters will be replaced to a "?" , besides the characters between 0x20 to 0x7E and the TAB character
n=2 means: all characters will be replaced to a "?" , besides the characters between 0x20 to 0x7E


Example: replaceChars=T,2;

2. You can change the replace character used by denoting R,xx in Replacechars (xx is the code for the replace char), example: replaceChars=T,2,R,0x40; will use @ as replace character.

3. When using T,n in the Replacechars functionality , any other replacechars characters in the string will be ignored (e.g. Replacechars=T,2,0x42,0x43 will ignore the switch from 0x42 to 0x43)
Note that when T,n is used , there is actually no need to replace any characters further (1A character is already replaced automatically without you need to do anything)