Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to get rid of Insertion Charactor ""?

Hello,

I have a flat file, like:

"02323";"05";"00";"HV";"Dirk";"Ellinghaus";"19651231";0;1;;25;44;"12";.........

"82344";"05";"00";"HS";"Thomas";"Schmidt";"19730202";0;2;;33;23;"12";.........

.........

some fields with insertion character"" some fields without "".

It is difficult for content conversion.

Recordset.fieldNames ID, ConNo, ParNo, CusNo, ....

Recordset.endSeparator "

Recordset.beginSeparator "

Recordset.fieldSeparator ;

I think it would not be a good idea with Text functions for every field to get rid of insertion characters.

A UDF could be an alternative? How to do it?

Thanks in advance!

Rene

Former Member
Not what you were looking for? View more on this topic or Ask a question