Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending .txt files without spaces.
Message
From
08/05/2001 11:08:43
 
 
To
08/05/2001 11:04:23
Jorge Villasenor
Luz y Fuerza Del Centro
Mexico City, Mexico
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00504731
Message ID:
00504733
Views:
15
Hey Jorge,

Well...if the actual data has no spaces in it then you could use FILETOSTR, STRTRAN, and STRTOFILE to reformat (removing spaces) and rewrite the file, then import it as fixed-length.


>I have this .txt file with 5 columns of info, it is delimited with blanks, each record is something like this:
>
>"NA048032 <20 spaces> 040502010100 <15 spaces> 000800 <20 Spaces> A05075300 <5 spaces> 00DIN"
>
>when using:
>
>APPEND FROM file.txt DELIMITED WITH BLANK
>
>I need to have a table with enough columns for every space in the record!!!
>
>Question: How can i ignore those nasty spaces?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform