davieboy_xr

I have a .csv file which i use to import into a database.Some of the csv values have number values but mostly text. My problem is that when retrieving the records within the database i have Speech marks around the text.This is what the .csv file looks like:

23 , "hello" , "This" , "is" , "some" , "text", 12


No problems with the actual import of the data, but it does look horrible when when displaying on a form. Is there anyway i remove these speech marks, and would this be done after using the split() function.
Help much appriciated. thanks dave

HunterVF01

You may want to do a Replace before the Split.

davieboy_xr

Bit lost now...... here`s wht i do with the csv file


so would i have to pass strL through replace, but how would i get it to recognise where the quotes are?

HunterVF01

Try this..

davieboy_xr

thanks works a treat ..cheers for your time