Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help Needed - Reading Tab Deliminited file 1

Status
Not open for further replies.

laado

Programmer
Oct 17, 2002
35
AU
Hi Guys
I am posting this again, i lost all the Replies of
the thread i previously started.

Here is my Question..

At work i have got a assignment to read a TAB Delimited file
and i am new to this role and trying without any Success.
Currently i am using a Visual Basic App to read the Tab Delimited file and save it as a Fixed length file.

Here is small example of file :
All records are seperated by CHR(13) + CHR(10)
All fields are Seperated by TAB CHR(9)

ORDER ORDCONF TEST90462752-R10 579637 0
PRODQNTY 1 605-CHP-004 6
PRODQNTY 2 605-CFT-001 9
PRODQNTY 3 605-ASP-002 2
END

Thanks in Advance

:(

 
It appears that it doesn't specifically have to be Clipper that you use to achieve your result. This being the case, open the file with Excel then do a SaveAs to whichever format you wish. If you need to save it in a dBase format, you can SaveAs comma delimited, then create the structure and import using your dBase editing program. I use a little program called DBX.EXE which I found somewhere and is much better than DBU.EXE. Leave your email if required.

Regards.
 
Take a look at the solution in the FBIZZELL thread. I bumped it so you could find it better.
 
Thanks Scal and thanks Elkari for Bumping that very good
example to me , i will give it a go tomarrow.

Also Scal most of the time i wouldn't know the filenames
and i want to automate this Reading process.

Thanks a lot guys :)
 
Thanks alot Elkari, It was a perfect example worked after
couple of minor changes, well Deserve a BEER.

Cheers

 
Elkari,

Some time ago you created a tabin and readln function for me and it has worked flawlessly until just recently when I started having a problem it going beyond the chr(13)and Chr(10) markers. I need your help once again.

Frank
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top