Thanks for help!



>Take a look at message#1045090
>>Hi,
>>I have problem to append table from CSV file.
>>When CSV file has structure like
>>"Colname1";"ColName2","Colname3_Memo";"ColName4";
>>
>>and "ColName3_Memo" has values with CHR(13) between " "... then APPEND FROM (lcFilename) DELIMITED WITH ; works wrong...
>>It can't recognize fields with double quotta and break character between...
>>
>>Is there way to APPEND table from CSV using APPEND FROM command? or need to write own code for such cases?
>>
>>Here little example of CSV file... (by the word.. MS Excel recognize this format excellent)
>>
>>"Artikelnummer";"Artikelbezeichnung";"Artikelbeschreibung";"Hersteller";"Bestellnummer";"EP HEK";"Bildpfad"
>>"DPKLLD029";"Delphin EUROS-I300P BLACK DP0113";" Delphin EUROS-I300P BLACK DP0113
>>- 1 x INTEL PENTIUM 4-800 3000MHz
>>- 1 x DELPHIN Starter Pack
>> 3 Jahre Garantie
>> 1 Jahr kostl. Pick-UP Service
>>- 1 x MS OEM Tastatur Basic schwarz bulk PS/2
>>- 1 x MS OEM Maus Basic schwarz bulk USB
>>- 1 x NEC FDD 3.5 intern schwarz
>>- 1 x DELPHIN MiDi-Tower 4108B schwarz
>>- 1 x Netzteil 300W pPFC ATX 2.0 120mm Lьfter
>>- 1 x WD FestplatteE PATA 80GB 7200rpm 2MB
>>- 1 x MSI MS-7060 661FM2-LSR V+A+L (478)
>>- 1 x LG DVD-ROM 16x52x intern bulk schwarz
>>- 1 x Speichermodul PC400 512MB Original
>>- 1 x Win DVD4 OEM
>>- 1 x MS OEM WINDOWS XP PROFESSIONAL
>>";"LEO";
>>
>>Thanks
>>Denis.