Read tab delimited text file

[Karl]

How do you read a tab delimited text file? The file has 3 colums of data.

I can read fixed width text files using the left and mid functions.

I had rather not use transfer text and import specs.

[kingston via AccessMonster.com]

Is the tab character in the file a consistent number of spaces? If so, you
could try using the functions Len() and Instr():

FirstPart = Mid([Input],1,Instr([Input]," ")-1)
SecondPart = Mid(Mid([Input],Len(FirstPart)+6),1,Instr(Mid([Input],Len
(FirstPart)+6)," ")-1)
ThirdPart = Mid([Input],Len(FirstPart)+Len(SecondPart)+11)

Karl wrote:

>How do you read a tab delimited text file? The file has 3 colums of data.

I can read fixed width text files using the left and mid functions.

I had rather not use transfer text and import specs.

--
Message posted via http://www.accessmonster.com

[Karl]

"kingston via AccessMonster.com" <u27511@uwewrote in message
news:6a0437f5b6755@uwe...

Is the tab character in the file a consistent number of spaces?

Its not.
If so, you

could try using the functions Len() and Instr():

FirstPart = Mid([Input],1,Instr([Input]," ")-1)
SecondPart = Mid(Mid([Input],Len(FirstPart)+6),1,Instr(Mid([Input],Len
(FirstPart)+6)," ")-1)
ThirdPart = Mid([Input],Len(FirstPart)+Len(SecondPart)+11)

Karl wrote:

>>How do you read a tab delimited text file? The file has 3 colums of data.

I can read fixed width text files using the left and mid functions.

I had rather not use transfer text and import specs.

--
Message posted via http://www.accessmonster.com

[kingston via AccessMonster.com]

Copy the tab character from the file and paste it into the function Asc():

?Asc("tab character here")

Then use Chr(result) to find the tabs in the file.

Karl wrote:

>Is the tab character in the file a consistent number of spaces?

Its not.

If so, you

>could try using the functions Len() and Instr():

[quoted text clipped - 8 lines]

>>>
I had rather not use transfer text and import specs.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

[pietlinden]

Karl wrote:

How do you read a tab delimited text file? The file has 3 colums of data.

I can read fixed width text files using the left and mid functions.

I had rather not use transfer text and import specs.

I'm baffled. Why not use import specs? Does your data not import
correctly if you use them? Seems the quickest and least painful way of
doing things. if you wanted to do things the hard way, I guess you
could read the file (check out LineInput) and then split it using Split
and then write the individual values into a record, but this seems like
an awful lot of work when the import spec will do exactly the same
thing and faster. So I suspect there's something you're not telling
us...