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?
"Do what you love and love what you do."