Wrapped lines in source splits lines in destination in another server

[former_member1124792]

Hi christian.georgi

I have seen your answers on file format. I thought you could help me out on this.

Will you be able to answer below question?

Thanks in advance.

I have a SAP BODS Pipeline setup to extract a table from Source to destination.

Source Data:

Destination File:

Invoice Address field is being truncated and starting as new line in destination which is creating problems. How can I handle this.. File is pipe separated and below is the simple pipeline setup

But when it is in BODS server the file looks good, but when I push to Azure Blob or send email of the same file, this problems are existed.

BODS Pipeline:

[chgeo]

You may have mixed me up. I have no idea what BODS is, sorry.
I watch tag SAP Cloud Application Programming Model, but not SAP Data Services.

[RichS]

Your source data has "newline" character(s) embedded within INVOICE_ADDRESS.

Option 1: If you don't want them in the destination, you can remove them in column mapping using the replace_substr function. For example: replace_substr(replace_substr(INVOICE_ADDRESS,chr(10),''),chr(13),'')

Option 2: If you need to retain them in the output, you can use text delimiters in file format. This will cause all character columns to be wrapped in the delimiter specified (double quotes in the example below). Note that you should then add column mapping to all character columns to "escape" any double quotes in the source data by doubling them up (ie prefixing each occurrence with another double quote). For example replace_substr(INVOICE_ADDRESS,'"','""').

Note too that whatever application is receiving the file has to support this methodology.

[former_member1124792]

I tried in the above way, but is showing syntax error. I am sorry if I am doing silly, I am new to BODS

Please guide me on this.

Regards

Krishna

[RichS]

Sorry - the syntax should be: replace_substr(replace_substr(INVOICE_ADDRESS,chr(10),''),chr(13),'')

My earlier post incorrectly used char(10) and char(13) - the function in BODS is chr (without the "a")