format coomand in ArcGIS 10-VB

Question

Hi,

I used "Format"command in Field Calculator in ArcGIS.9.x for formating Feild values.
Example: APN VALUES- 125 
             APN VALUES- 12
 I can format by using follwing structure 
1) format([APN],"0000") = result will be "0125" 
2) format([APN],"0000") = result will be "0012"

similaraly i  followed and calculated. 
But in ArcGIS 10.0 not able to calculate. Please let me know how to use the "format" command.

thanks
Ganesh

ratnakartini · Answer

Hi,

I used "Format"command in Field Calculator in ArcGIS.9.x for formating Feild values.
Example: APN VALUES- 125 
             APN VALUES- 12
 I can format by using follwing structure 
1) format([APN],"0000") = result will be "0125" 
2) format([APN],"0000") = result will be "0012"

similaraly i  followed and calculated. 
But in ArcGIS 10.0 not able to calculate. Please let me know how to use the "format" command.

thanks
Ganesh

Mr Ganesh i have the answer, hope it can help u and others outside...

Example:

BP_TEXT: 1

RESULT: 001

Calculation (Python)
!BP_TEXT! .rjust(3,'0')

Have a nice day....

Ratna, Putrajaya.

IABG_mbHIABG_mbH · Answer

Bart from Belgium, thank you very much!

The solution works beautifuly.

Jörg

BartBoute · Answer

Hello,

After a long search I found out that the answer is ZFILL in Python. Open the Field Calculator and choose parser: Python (and not VB Script)

Example 1
TERRID: OSK01
SZONE: A1
BPNR: 1
RESULT: OSK01A1001

Example 2
TERRID: OSK01
SZONE: X
BPNR: 1
RESULT: OSK01X0001

Calculation (Python)
!TERRID! + (!SZONE! .ljust( 2, '0' )) + (str(!BPNR!).zfill(3))

Can ESRI please give us a list of functions simular to FORMAT, that don't exist anymore in ArcGIS10, with the according function in Python?

Greetings :cool:,
Bart from Belgium