Remove spaces from file 1

[joeythelips]

Hi.

I'm using the following code to save an access table as a properly formatted csv file. However when i view the csv file in UNIX, spaces are appearing between the commas.
How can i prevent this?

Print #2, Str(meterref(i)) & "," & customername(i) & "," & Str(meterno(i)) & "," & Str(meterseq(i)) & "," & Str(Multiplier(i)) & "," & Reading(i) & "," & readingtype(i) & "," & Format(readingdate(i), "dd-mmm-yy&quot ' put a comma here followed by eg descripion(i) etc.

 

[HIM]

Hi

Using the Str function returns a string with a space in front.... one of those small VB things.... use the function Trim around it.... and you are set.... like this

Trim(Str(Value))

Have fun