Quotes

[Gary.Lowe]

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?

[vbuser1976]

Check the datatypes and try to change them, if you can. If you change the datatype of the "04" to integer, the quotes will not be saved and the value will be saved as 4.

Hope this helps.

[paulw]

Your going to catch it in a minute...

My mum, any time in the last 34 years

Seriously, once you have parsed the data, why not use the Replace function.

e.g. NewStr = Replace(OldStr, """", "")

This will strip off double quotes. Alternatively use Left$ and Right$ to trim off the first and last chars.

Cheers,

Paul.

[Gary.Lowe]

Thanks everyone

I managed to do it by seeing if """" was in the string.
I then used mid to return the vaue(if any) excluding the quotes.