topic Re: CSV Conversion Considering Edge Cases in Application Development and Automation Discussions

CSV Conversion Considering Edge Cases

Former Member — Fri, 14 Jan 2011 14:05:58 GMT

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

Re: CSV Conversion Considering Edge Cases

franois_henrotte — Fri, 14 Jan 2011 16:31:12 GMT

you just do

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

then you apply separators

Re: CSV Conversion Considering Edge Cases

oliver — Fri, 14 Jan 2011 16:38:50 GMT

Thanks François,

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

Best,

Oliver