Another Split problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text string for an address that I need splitting.
It's comma separated, and Has 5 fields, Address 1-5.

Problem is is that some addresses are from china so they will have

"Flat Num, Block, Road",City,Provence,address code,China

which is a problem because split will see the first field at "Flat num and
the third as Road".

Is there a way of getting around this? could use tabs (which excel can
produce) but not sure how to split with tab.
Sadly I can't use transfertext because the columns are not headed correctly
and there is data manipulation to do before storing it in the database.

Thanks
 
I've already answered how to use the Split function with tabs for you.
 
You must log in or register to reply here.

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

Splitting out a wrapped text entry 11
primary key - concatenated or autonumber? 6
Splitting a large field up into six new fields 3
relation problems 1
Splitting Tables 4
Pivot Table - problem with repeated fields 5
Splitting comma separated lines of an address for mail merge. 1
Import using Split Function 1

Back
Top