Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Text File Weirdness from 3rd party
Message
De
16/04/2013 09:54:38
 
 
À
16/04/2013 03:23:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01570974
Message ID:
01571063
Vues:
48
>Sometimes neccessary if text fieds include commas ;-)
>can be and often is done with excel, but Sergey showed the proper way
>
>
>>
>>A text file, that is comma delimmited, is being sent to us for processing.
>>
>>This is how the file usually looks......... no quotations in it.......
>>
>>
>>Value1,Value2,Value3
>>1000016,EPHA,107.38
>>1000119,EPHA,282.61
>>1000229,EPHA,40
>>1000260,EPHA,153.5
>>1000348,EPHA,350
>>
>>
>>But now the user is sending the file with Quotes in it...... like this....
>>
>>
>>"Value1","Value2","Value3"
>>1000016,"EPHA",107.38
>>1000119,"EPHA",282.61
>>1000229,"EPHA",40
>>1000260,"EPHA",153.5
>>1000348,"EPHA",350
>>
>>
>>Any idea how this is happening? We don't know what tools he is using to create the file, or how he is saving it.
>>
>>Thanks a bunch!


that way you can have a comma between the quotes
Peter
Peter Cortiel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform