Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Text File Weirdness from 3rd party
Message
From
16/04/2013 09:54:38
 
 
To
16/04/2013 03:23:00
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01570974
Message ID:
01571063
Views:
49
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform