>>Help me out here, guys. My brain's turned to mush.
>>
>>- I'm importing an XLS -> dbf
>>- a numeric val from the XLS becomes a string val in the dbf
>>- I need to express this as a 4-char field, right justified and prefilled with "0"s
>>
>>So 13 -> "13" and I need "0013"
>>
>>I can't seem to get it right, using different permutations of STR( X, 4) and PADL( X, 4, "0").
>>
>>I either end up with "" or "13"
>>
>>Any quick ideas before I go home?
>>
>>'ppreciate it
>>
>>Incidentally, I'm adding to this old FPD 2.6 system. But I'm testing the module in VFP7 where I can work more quickly. When I import in 7, the num field becomes a num, which I have to STR(). When I compile and link in FPD, and run the exe, I get a mismatched var error, cos the num field has become a char, and so doesn't need STR()ing.
>>
>>So it would seem that the functionality of IMPORT has changed.
>>
>>Terry
>
>

>? TRANSFORM(13,[@L 9999])
>

Thanks BB. That works fine too. But I think Tamar just pipped you to the post :-)

Cheers

Terry