Reading text file

[coolislandsurf]

Hi Everyone,

I am querying a database using Query Analyzer and saving the results to a csv file which looks like:

text ,text ,text ,text ,text
text ,text ,text ,text ,text
text ,text ,text ,text ,text


Notice the extra spaces after each "text". That is because the variables have different lengths in the database.

How can i save the individual text in an array without the extra spaces. Everything is comma delimeted?

Many thanks.

 

[TPM]

Use Trim or replace.