Flatten a flat file with 'Return" key

dataservices job design
1

Hello,
I am working on generating a csv file from data I read from salesforce. Using the attached configuration, i am able to do that and the job works perfectly fine without any issue. The separation of columns works perfectly. Once in a while, a user uses the Return or Enter key to enter data into a text field. Now the csv generation works fine and the entire field is treated as a single column. But the issue rises from the client side, where their system breaks down or cannot process the file correctly since it “sees” the return key in that field and messes up the mapping.
When i open the csv in notepad, it works fine. When i open the csv in Excel, it is still contained within a column, but it does show the return key format. So, is there a way to flatten that field as a continuous running text rather than have any formatting within it.

Cheers.

[/img]
Doc1.doc (144.0 KB)

BOB_US (BOB member since 2006-03-16)

2

You can just use a replace_substr(chr(10),’ ') … on it.

I’ll often cut and paste the data into a script that dumps the ascii value of each byte. Saves from guessing.

jlynn73 :us: (BOB member since 2009-10-27)