linking text files that have multiple delimiters to Microsoft access

[shaan1980]

I have a file that is primaryly tab delimited .
from all the columns that are generated through the tab delimiter option one column contains a comman seprated value that I need to break up and push into two seperate columns . Can you please suggest a method whereby I don't need to create any file processing everytime I need to do this and it just links in this manner

[jvmills]

Create a query containing 2 calculated fields which use text functions such as instr and left or mid to break up your single field into 2 fields based on the location of the comma.

For example something like this -
Newcolumn1: Left(OriginalColumn, instr(OriginalColumn, ",")+1)

That would give you everything before the comma in a new calculated field called NewColumn1

Similarly use a Mid or right function to return everything after the comma in a second calculated field

Then simply use the query as the source for your tab delimited output.

[shaan1980]

thank you