I am trying to separate this string in this file and put the information 

into tables uploading these company names. 



There are over 26,000 records and they are really tricky trying to 

separate the company name, street number, street name , suite if it has 

one , city name , state and zip and a phone number if there are [] .  here 

are a few lines below.  I can get the city and state and zip but the 

address is the problem .  I opened it in excel to see the columns there is 

no fixed length. Please help! I am doing this in asp using the code below 



set fileObj = CreateObject("Scripting.FileSystemObject")



if isobject(fileObj) then

set navfile = fileObj.opentextfile("c:\Inetpub\webpub\shipper.txt")

end if



while not navfile.atendofline

nav = navfile.readline .......







here is a few lines of the txt file

MAILCODE	SHPCONNAME	ADD1	ADD2	ADD3	ATTN	PHONE

10001		5399 LAUBY ROAD	"NORTH CANTON, OHIO  44720"		

	(   )    -

10002	A. AHLSTROM PUMPS INC.	PROJECT WCM-21	615 SHEFFIELD ROAD

	"EASLEY, S.C. 29641"		SAXC113BRECHS4

10003	A. FURNTE TOBACCO CO.	1310 N. 22ND ST.	"TAMPA, FL 33605"

			HLCU022000528

10004	A.D. WEISS LITHOGRAPH CO.	2025 MCKINLEY ST.

	"HOLLYWOOD, FL 33020"			ACLU1671LVZIB8

10006	FRITZ CO ATLANTA	4694 AVIATION PKWY	SUITE A	"ATLANTA, 

GA 30349"		HLCU122017246

Thanks so much for any help.



SB