cancel
Showing results for 
Search instead for 
Did you mean: 

CPI DS Replace LineFeed with Carraige Return + Line Feed

cca4c
Explorer
0 Kudos

Hi,

I need to replace the ASCII linefeed command to carriage return and line Feed. I do a replace_substr as following regarding to https://launchpad.support.sap.com/#/notes/2007254:

replace_substr(XXXXXXXXXXXXXXX.Data, chr(10) , chr(13)chr(10))

In validation, it says: Invalid expression syntax line:1, char:54, <chr> in <Data> mapping expression

Any Ideas?

Accepted Solutions (1)

Accepted Solutions (1)

cca4c
Explorer
0 Kudos

Thanks for the advice with the '||' this is syntactically correct. Unfortunately, there was an erro saying <chr> is not accessible, check dataflow.

Anyway, I managed to get the linefeed with onboard utilities. My Source was an odata service with one block of data. I managed to split the odata service into entries (each entry per line in Data) so, the tofile target can manage the line as new entry. Therefore the ds engine places a crlf itself after the entry. so there is no need for a replace logic

Answers (1)

Answers (1)

jeffrey_kresse
Employee
Employee

Could you try concatenating the CRLF? Like this: chr(13)||chr(10)