topic Re: Character Substitution - Remove Carriage Returns in Qlik Replicate

Character Substitution - Remove Carriage Returns

acope307 — Tue, 02 Nov 2021 16:19:37 GMT

Hello! We are trying to remove carriage returns from a file and replace it with space. We are going from Oracle to ADLS Gen 2, export to CSV. The HEX value is: 0D0A. Everything we try does not want to remove the carriage return.

What happens is when we process the file into parque, it creates additional rows. This is on both the historical load and csv load.

Can anyone help?

Re: Character Substitution - Remove Carriage Returns

john_wang — Wed, 03 Nov 2021 14:09:52 GMT

Hello @acope307 ,

Both OD and 0A should be replaced by space, like:

Hope this helps.

Regards,

John.

Re: Character Substitution - Remove Carriage Returns

acope307 — Wed, 03 Nov 2021 15:58:31 GMT

Thank you John! It worked 😁😀!!

I very much appreciate your response, as simple as it is...I have not been able to get a response from the helpdesk.

I appreciate you and thank you!

Neil

Re: Character Substitution - Remove Carriage Returns

john_wang — Wed, 03 Nov 2021 23:19:41 GMT

Hello Neil,

Glad to hear that 😀 Cheers.

John.