Parse a string of text from a linked .txt file

S

Steven M. Britton

I use a system to send packages US Mail, the reporting
functions aren't the best. So it exports a file that is
tab delimited, so with that I am able to link to it and
break the fields out that I need. (ie: Address, ZipCode,
Postage, Tracking_Number).

Now what I need to do is break down the address field
further. It currently exports the address field into one
column and breaks it up by commas. So I have Name,
Company, Address1, City, State, Zip - How can I parse this
data into Access via a Query or VB Code.

I took a semester in Java for kicks and was able to learn
about a function Java as indexof. - I would assume that
Microsoft has something similar built into there
programming language. (We can't let SUN show them up.)
So are there any MVP's that understand my question and can
offer a solution?

-Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MVP Needed - Parse a string of text from a linked .txt file 1
parse some text from an inconsistent text field 6
Parsing a string 10
Parse text string and insert characters 5
parsing query 5
parse a Text file 2
Parse a txt file and save as csv? 4
Split delimited field data TWICE to populate specific other fields 3

Top