Skip to Content
0
Former Member
Mar 24, 2010 at 04:32 PM

How to get rid of Insertion Charactor ""?

50 Views

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