Hi Jorge,
I'm a little confused. Do you want to KEEP the spaces when you append (ie, your table field is 25 long and you want the LEFT(25) of the text), or do you want to IGNORE the spaces (ie, ALLTRIM() the text)?
In either case, APPEND FROM ... DELIMITED probably won't work in this situation. There are several options, depending on your answer to the above.
>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?
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?