Re: Extra spaces in CSV file generated from VFP9SP2 when using Varchar fields

On 2017-11-27 11:59, Koen Piller wrote:

if you want to avoid the extra spaces at the end trim() and or alltrim() is your friend.

Koen

Koen,

I think there's a misunderstanding. Please tell me how using a COPY TO MyCSVFile TYPE CSV can be manipulated with a TRIM or ALLTRIM? Are you saying I should devise some sort of construct like the pseudo-code following this to trim everything before the COPY TO ... TYPE CSV command?

FOR EACH Column in Table.Columns REPLACE Column with ALLTRIM(Column) in Table ALL ENDFOR

I doubt that's what you would do, so enlighten me please.

Thanks, --Mike