Glen
What is "delimited with" in your terms?
1. "John",25,"New York"
2. *John*,25,*New York*
3. "John"*25*"New York"
In Fox terminology:
"John",25,"New York"
APPEND FROM text DELIMITED
The " " delimiters for text fields and the , as field separator ar both
default so
nothing has to be specified.
*John*,25,*New York*
APPEND FROM text DELIMITED WITH "*" [WITH CHARACTER "," ]
The , as field separator is the default so the WITH CHAR clause in not
needed.
"John"*25*"New York"
APPEND FROM text DELIMITED WITH '"' WITH CHARACTER "*"
APPEND FROM text DELIMITED WITH CHAR "*"
As " is the default text field delimiter WITH '"' is not needed.
John*25*New York
APPEND FROM text DELIMITED WITH CHAR "*"
This will work too. The "" delimiters are not required, except for practical
reasons where the text field itself contains a field separator
"Brown, Bill",34,New York
The keyword TYPE is not required.
-Anders
> I am trying to import a text file into VFP6. I have defined the table
> in accordance with the columns in the text file.
> (from a template provided by the sender)
> The text file is sent to me delimited with the asterisk (*). When I try
> to
> APPEND FROM myfile.txt delim with '*' I only get the first column
> of data.
> If I repace all the * with a comma, it imports but some of the fields
> are displaced.
> The same thing happens when I try to use the import wizzard.
> What is happening?
> Thanks
> Glen Mettler
--
Shar Feldheim, President
PC Software, INC - Visual Foxpro Application Development
"Programs are NOT foolproof...the fools are TOO ingenious"
***************************************************