>>Fabio,
>>
>>>COPY is a copy, then if a field is SPACE(3) copy must put 3 spaces into the target.
>>
>>I disagree. It must be TRIMmed because it is a CSV format. If not we would end up with a SDF that has extra spacers.
>>
>>
>>Agnes
>
>and then is this wrong ?
>

>CREATE CURSOR test1 (v1 V(3) DEFAULT 'v ',v2 V(3) DEFAULT 'v ')
>APPEND BLANK
>COPY TO test1.txt DELIMITED WITH "" WITH CHARACTER "|"
>MODIFY FILE test1.txt
>

Fabio,

I will have a closer look tomorrow.

Anyway, compare with

CREATE CURSOR test1 (v1 C(3) DEFAULT 'v ',v2 C(3) DEFAULT 'v ')
APPEND BLANK
COPY TO test1.txt DELIMITED WITH "" WITH CHARACTER "|"
MODIFY FILE test1.txt

Something's strange with VARCHAR

Agnes