This content has been marked as final. Show 3 replies
You cannot have row delimiter part of data for delimited files. You may want to explore complex files instead.
While i was reading your post i remembered an issue that madded me. I don't know Oracle CRM, but a possible workaround could be to create a temporary Oracle table and load all data inside it. After that load in CRM only valid rows.
We faced similar problem. Try removing new line character using replace function.
REPLACE (LAST_NAME, CHR (10))