CSV Conversion Considering Edge Cases

[Former Member]

We currently have a problem converting an internal ABAP table into a CSV file.

Example:

UserID;Name;Pet1;Pet2

D012345 Klaus Meier Dog;Bruno Cat"Kitty

should become

D012345;"Klaus Meier";"Dog;Bruno";"Cat ""Kitty" (<- content delimiter, escaped)

Is there a specific functional module where you can define whether to use such delimiters or not? And what would happen if there is - per accident - only one double quote in the field, can this be escaped e.g. by a second double-quote like Excel does it?

We are running on NW 7.01. Any help highly appreciated.

Best,

Oliver

[Former Member]

Thanks François,

but what about having the delimiter as part of the record as in "Dog;Bruno"?

Best,

Oliver

[franois_henrotte]

you just do

REPLACE ALL OCCURRENCES OF '"' IN my_struc WITH '""'.

then you apply separators

[oliver]

Thanks François,

but what about having the delimiter as part of the record as in "Dog;Bruno"?

Best,

Oliver