Issue Statement: Remove line feed/CRLF from text fields.

Issue: If the input text field has line feed/CRLF, then data gets shifted to subsequent fields in mapping, hence creating wrong target data.

Logic: Remove line feed/CRLF from the text

Solution: Create a simple UDF to remove line feed/CRLF

UDF Signature:

UDF Code:

String Input_Text1 = null;

String Input_Text2 = null;

Input_Text1 = Input_Text.replaceAll(“\\n”, “”);

Input_Text2 = Input_Text1.replaceAll(“\\r”, “”);

return Input_Text2;

Note: I am not a great Java coder 🙁 . You can use a single String field instead of using two String fields, as I did.