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

On Mon, 27 Nov 2017 11:43:00 -0500, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:

But when I use varchar v(N) field declarations, it appends spaces to the end of the field values:

Hi Mike,

you can resolve in this way:

set fields GLOBAL set fields to

set fields to PseudoID = rtrim(PseudoID), Zip3, Prov03, Prov03Other = rtrim(Prov03Other), Prov06, Prov07, Prov07Other = rtrim(Prov07Other), Prov08

copy to MyCSVFile type CSV

set fields to set fields LOCAL

Be careful with the order of the various "set fields ..." commands!