General information
Category:
Coding, syntax & commands
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only