Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from CSV
Message
 
To
03/11/2005 10:00:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01064863
Message ID:
01064952
Views:
16
Glad I could help. ;o)

>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.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Reply
Map
View

Click here to load this message in the networking platform