How to replace char. field with numeric field padded with 0's

[muckslush]

I have a .dbf table with several fields. I would like to replace a new char. field that I created (c, 10) with the values from a numeric field (n, 10), padding the first several places with "0"'s. I know how to do this when using 2 character fields, but can't get it right when trying with num>char. Thanks in advance.

 

[DSummZZZ]

Try this on one of the records:
REPLACE charfield WITH Padl(ALLTRIM(STR(numfield)), 10, '0')

If that's what you want, add ALL to the command:
REPLACE ALL charfield WITH Padl(ALLTRIM(STR(numfield)), 10, '0')

To replace every record.

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[TamarGranor]

When I have a problem like, rather than trying the replacement on a record, I just test it from the Command Window:

?PADL(ALLTRIM(STR(numfield)),10,'0')

If that gives me the right results, I can do the replace.

Tamar

 

[alvechurchdata]

I may be paranoid but I'd go one step further than Tamar and take a look at all the data first:

Select Padl(Alltrim(Str(numfield)),10,'0') As Dummy ;
  From myTable ;
  Order By Dummy

I can then have a quick read down the output to see that there's a nice consistent pattern. The Order By clause should throw any weird results to the top or bottom of the list.

I would also do a backup first.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[severach]

I avoid putting constants into the code like 10 since they are likely to change later. I'd like the code to adapt.

REPLACE ALL charfield WITH Padl(ALLTRIM(STR(numfield)), len(charfield), '0')

This also makes it obvious that 10 isn't some value picked out of thin air.