Problem importing from .txt

[Sandro Lunghi]

I'm importing addresses from a .txt file. Some addresses are simple number & road (type 1) but some have a comma separating two separate pieces of data, eg house name, road (type 2). I have used the following syntax:

load data local infile 'xxx.txt'
into table NameAddress
fields terminated by '\t'
lines terminated by '\r\n';

The type 1 address imports perfectly but type 2 imports the address but puts the data in inverted commas, eg "House Name, Road Name" which I don't want. I have tried to get around this by inserting a optionally enclosed by "" line but this doesn't seem to work:

load data local infile 'xxx.txt'
into table NameAddress
fields terminated by '\t'
optionally enclosed by ""
lines terminated by '\r\n';

Can anyone help me?

Many thanks