Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Removing CR * LF from CSV file
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01440894
Message ID:
01440920
Vues:
49
>CSV with embedded memo if not handled with this type of APPEND. Search here for 'Excel memo' by Cetin Basoz - he showed different techniques for getting information with memo fields in and out.
>
>>No that's my problem - the csv file was created from copying memo fields which have embedded cr and lf characters
>>
>>I have no control over the way the csv file was creted
>>
>>Thanks
>>
>>Colin
>>
>>>The CR+LF are end of line combination. APPEND FROM command will handle it.
>>>
>>>>
>>>>I'm triyng to append a csv file as type delimited into a VFP table - the csv file has carriage return and line feed characters which need removing prior to the append
>>>>
>>>>How can i do this?
>>>>

thanks a lot
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform