special characters

Need to trap CR/LF characters on input to AE pgm from db staging table

Hi all!

I have an AE that is getting input from a database staging table which is populated from an external system. One of the fields is a Char(400) text field which will potentially have CR/LF characters in it. These are causing significant errors, as the AE pgm which processes the data sees the CR/LF and assumes a new record of data has been encountered.

So I find that I need to trap the CR/LF characters and handle them somehow (temporary translation?) to prevent these issues.