Delete space in file name

[poupou]

Hi,
I wouild like to save table in file name 'toto' + no
+ '.dbf'

But when I try with:
no = str(89)
copy to 'toto' + no + '.dbf'

I'am able to create file, but is name is
toto 89.dbf

My program put 8 spaces between toto and 89

I try to with
copy to 'toto' + trim(no) + '.dbf'
But it's was the same result

Thanks and sory for my bad english

Redg

 

[csimion]

Try copy to 'toto' + alltrim(no) + '.dbf' Cristian

 

[rgbean]

Redg,
You need to trim the leading spaces, and trim() or rtrim() handle trailing spaces. Use ltrim() or alltrim(). Try:
copy to 'toto' + alltrim(no) + '.dbf'

Rick

 

[Walid]

copy to 'toto' + ALLTRIM(STR(no))+ '.dbf'
Walid Magd
Engwam@Hotmail.com