How to handle Carriage Returns in Qlik Replicate when replicating from Oracle

[SachinB]

This article provides you with information on how to handle carriage returns in Qlik Replicate while replicating from Oracle.

Resolution

The hex value for a carriage return (CR) followed by a line feed (LF) is 0D0A.

In this case, 0D represents the carriage return (CR) and 0A represents the line feed (LF). This combination, 0D0A.

Both OD and 0A can be be replaced by a space using Character Substitution in the Qlik Replicate Task Settings.

1. Open the Qlik Replicate task
2. Open the Task Settings
3. Open Character Substitution in the menu on the left
4. Click Add Character and add the following two:
   
   U+0D (Source Character) to U+20 (Substitute Character)
   U+0A (Source Character) to U+20 (Substitute Character)
   
   
   
   
5. Click OK to save

Environment

Qlik Replicate