remove LF line feeder

muthu7 — Mon, 28 Feb 2022 07:50:45 GMT

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

Re: remove LF line feeder

john_wang — Mon, 28 Feb 2022 07:57:06 GMT

Hello @muthu7

Check this article Remove Carriage Returns ,

hope this helps.

Regards,

John.

Re: remove LF line feeder

Heinvandenheuvel — Tue, 01 Mar 2022 18:06:27 GMT

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)

topic Re: remove LF line feeder in Qlik Replicate

remove LF line feeder

Re: remove LF line feeder

Re: remove LF line feeder