topic Re: format coomand in ArcGIS 10-VB in Data Management Questions

format coomand in ArcGIS 10-VB

PoovalingaGanesh — Fri, 29 Jul 2011 06:25:20 GMT

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

Re: format coomand in ArcGIS 10-VB

BartBoute — Wed, 07 Sep 2011 10:24:06 GMT

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

Hi Ganesh,

We have exactly the same problem here. A good working VB-function in ArcGIS 9.3.1 can't be used in ArcGIS 10, because the FORMAT function isn't supported anymore in AG10's field calculator.

Please let me know if someone solved the problem.

Thanks,

Bart Boute
BELGIUM

Re: format coomand in ArcGIS 10-VB

IABG_mbHIABG_mbH — Fri, 09 Mar 2012 08:13:22 GMT

Hello ESRI,

I have the same problem. Is there a solution in the meantime?

Thanks,

Jörg

Re: format coomand in ArcGIS 10-VB

BartBoute — Fri, 09 Mar 2012 10:17:08 GMT

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

Re: format coomand in ArcGIS 10-VB

IABG_mbHIABG_mbH — Fri, 09 Mar 2012 12:03:55 GMT

Bart from Belgium, thank you very much!

The solution works beautifuly.

Jörg

Re: format coomand in ArcGIS 10-VB

ratnakartini — Mon, 18 Feb 2013 06:17:00 GMT

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.