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.
I'm stuck on how to isolate the CR/LF characters in the field in question. There may be multiple occurrences of the CR/LF in the field. I reviewed the CHAR(), CODE(), and STRING() Peoplecode functions but either I'm missing something or they won't do the trick.
Anyone dealt with this previously? Any ideas?
|Required Peoplesoft HRMS Functional Training||PeopleSoft Functional||05/07/2013 - 10:29pm|
|Error while saving Voucher||PeopleSoft Functional||05/02/2013 - 1:55am|
|santosh asking que||PeopleSoft Technical||04/30/2013 - 10:22am|
|How can i implement Email functionality to alerts in peoplesoft.||PeopleSoft Technical||04/30/2013 - 5:01am|