topic Re: Handle the escape character in Qlik Replicate

Handle the escape character

eksmirnova — Tue, 18 Apr 2023 17:15:17 GMT

I am looking for a recommendation regarding the "\" escape character. What we need to do in order to handle escaping the escape character.

I know we can replace that character in Qlik task but we are worried that will end up replacing characters that we do not want to be replaced.

We actually only want to replace the \ when it precedes a double quote. Is there an option to replace \ only when it precedes a double quote?

Qlik task configuration:

source - DB2, target - ADLS storage, Full load/Store changes

Re: Handle the escape character

Heinvandenheuvel — Tue, 18 Apr 2023 21:33:42 GMT

What have you tried? What was the result?

It would seem you need a simple transformation with <replace> as Fx. Do NOT use <replaceChars> for this

I tried expression: replace($txt,'\"','"') Parse, and provide: $txt = abc"abc\abc\abc\"abc\"abc Test, and result: abc"abc\abc\abc"abc"abc

Is that not what you want? - of course you need to replace $txt with your column name.

hth,

Hein.

Re: Handle the escape character

john_wang — Wed, 19 Apr 2023 01:23:45 GMT

Hello @eksmirnova ,

Besides @Heinvandenheuvel comments, another option is using JSON/Parquet format rather than CSV as escape character is relevant to CSV format only.

Hope this helps a bit.

Regards,

John.

Re: Handle the escape character

john_wang — Wed, 19 Apr 2023 01:27:42 GMT

Hello @eksmirnova ,

I'd like to say thanks for you opening the ticket with sufficient and clear information! With source/target DB types, A clear description with sample... I'm sure you are Replicate expert, thank you so much for your excellent support!

Regards,

John.