nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

field calculator - copying field without last letter/number

MassimoSpirlandelli

I have to copy a field (text) into another field (text) except the last letter/number.

For istance:

in field "A" with attribute "1111A"

I want to get just 1111 in field "B"

how can I do it?

thank you in advance.

Vind meer berichten getagd met

Accepted answers

SepheFox

Hi Massimo, in the field calculator, choose the Python parser, and type:

!A![:-1]

All comments

DanPatterson_Retired

"1111A" is the value

In python for example

>>> a = "1111A"

>>> b = a[:-1]

>>> b

'1111'

>>>

so in the field calculator, you would setup a new field probably text if you can't guarantee all the slicing will be numeric, then use the field calculator syntax with the python parser selected a

oldfield[:-1]

the : means everything up to and -1 means the last one (counting backward from the end. There is a whole section on field calculations in the online help files... ie from the 10.3 help Fundamentals of field calculations—Help | ArcGIS for Desktop