Hi All

I have a file which is in the following format

23:0:12:"Hello":"":"":"04":

I can split thwm up into seperate fields and enter the values in the database.

The trouble is the ones in quotes get input into the database with quotes.

i.e. Hello would be "Hello" in the database and a blank line would be "". Also 04 would be input into the database as "04".

How can I get rid of these quotes before adding the value to the database?