Another Split problem

[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

 

[Douglas J. Steele]

I've already answered how to use the Split function with tabs for you.