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; } } }

I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VALUE

OLANIYANOLAKUNLE

I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VALUE I.E "FIGURINE" , I WANT TO EXTRACT LETTER "F" & "R" TO FORM "FR". PLEASE HELP ME

Najděte více příspěvků označených jako

Accepted answers

T__WayneWhitley

So have you already got this in a format you can read in ArcMap?...if so, have you tested that query to select the records you want to delete? I'm not sure what you are saying, are you stuck somewhere in this process?

If that query works, i.e., you've opened the attribute table and switched selection (or used 'not like' in your query) and satisfactorily confirmed this is what you want to keep, then execute the delete process. On the remaining set, then execute the calculate field process, as in the following (I didn't test it, but will follow Chris example, which looks good to me):

arcpy.CalculateField_management(myFC,"NEW_FIELD","!OLD_FIELD!.split(';')[1][0:-1]","PYTHON_9.3","")

....make the necessary adjustments in field calculator syntax; essentially this is the operative Python syntax to 'extract' your text:
.split(';')[1][0:-1]

All comments

RhettZufelt

strings are iterable, so the first index will be the first letter.
then I get the total number of characters, divide by two, and extract that one.

>>> string = "FIGURINE"
>>> string[0]
'F'
>>> string[len(string)/2]
'R'
>>> string[0] + string[len(string)/2]
'FR'
>>>

R_

ChrisSnyder

"Field calculator expresion might look like:".upper()

arcpy.CalculateField_management(myFC,"NEW_FIELD","!OLD_FIELD![0] + !OLD_FIELD![len(!OLD_FIELD!)/2]","PYTHON_9.3","")

Anonymous User

"Field calculator expresion might look like:".upper()

Haha- Too funny! There needs to be a "Like" button for situations like this...

OLANIYANOLAKUNLE

Thanks a bunch, csny490 & rzufelt your suggestions worked perfectly for me.

OLANIYANOLAKUNLE

I have alot of annotation text attributes imported from AutoCAD, i want to delete all the annotations like the following;

{\fArial|b0|i0|c0|p34;14.50m}
{\fArial|b0|i0|c0|p34;\L0.0203 ha}
{\fArial|b0|i0|c0|p34;161° 34'}
{\fArial|b0|i0|c0|p34;93° 10'}

and i want to delete the values such as this {\fArial|b1|i0|c0|p34;} and leave 426 for the ones that appear like this {\fArial|b1|i0|c0|p34;426} and the same for {\fArial|b0|i0|c0|p34;KAF 8816}, i want to delete {\fArial|b0|i0|c0|p34;} and leave KAF 8816.

Please do you have any suggestions. Thanks

T__WayneWhitley

You mean something like this?:

>>> text = ['{\fArial|b0|i0|c0|p34;14.50m}',
 '{\fArial|b0|i0|c0|p34;\L0.0203 ha}',
 '{\fArial|b0|i0|c0|p34;161° 34}',
 '{\fArial|b0|i0|c0|p34;93° 10}']
>>> for anno in text:
 anno.split(';')[1]

 
'14.50m}'
'\\L0.0203 ha}'
'161\xb0 34}'
'93\xb0 10}'
>>>

...ah, but think you want to get rid of the last bracket character too -- use the combo 'split' and string slicing py methods:

>>> for anno in text:
 anno.split(';')[1][0:-1]

 
'14.50m'
'\\L0.0203 ha'
'161\xb0 34'
'93\xb0 10'
>>>

OLANIYANOLAKUNLE

I want to delete all the first set of annotations i.e

{\fArial|b0|i0|c0|p34;14.50m}
{\fArial|b0|i0|c0|p34;\L0.0203 ha}
{\fArial|b0|i0|c0|p34;161° 34'}
{\fArial|b0|i0|c0|p34;93° 10'}

and for these ones, I want to remove the unwanted characters and keep the ones I need i.e delete the values such as this {\fArial|b1|i0|c0|p34;} and leave 426 & the same for {\fArial|b0|i0|c0|p34;KAF 8816}, i want to delete {\fArial|b0|i0|c0|p34;} and leave KAF 8816, something of this nature.

T__WayneWhitley

Well, there must be a way to select the annos to be deleted?
As for the portion you want to keep, following Rhett's example above, you could apply the split/slice technique I already demonstrated. I was just using your sample text in a list....you can apply it also as Chris suggested in a Python field calculation - in this bare-bones example, say you want to keep '14.50m':

>>> text = '{\x0cArial|b0|i0|c0|p34;14.50m}'
>>> text.split(';')[1][0:-1]
'14.50m'
>>>

That's not the only way to do it, but fair enough... looks like your bigger challenge will be the means to eliminate the anno you want to keep.

(er, I mean, eliminate the anno you don't want to keep.)

OLANIYANOLAKUNLE

I want to use an sql expression like this: "TEXTSTRING" LIKE '%fArial|b0|i0|c0|p34%' to remove all the annotations like that, then delete the values such as this {\fArial|b1|i0|c0|p34;} and leave 426 for the ones that appear like this {\fArial|b1|i0|c0|p34;426} and the same for {\fArial|b0|i0|c0|p34;KAF 8816}, i want to delete {\fArial|b0|i0|c0|p34;} and leave KAF 8816.

T__WayneWhitley

OLANIYANOLAKUNLE

Please how do I compose this arcpy script to select any text that has "ha", I tried the script below and that is the error message I got. Thanks

>>> arcpy.SelectLayerByAttribute_management("HTNT_Annoss", "NEW_SELECTION",'"TEST" LIKE '%ha%'')
Runtime error
Traceback (most recent call last):
File "<string>", line 1, in <module>
NameError: name 'ha' is not defined
>>>

T__WayneWhitley

...right, Python thinks you want variable substitution...number of different ways to handle this, but try:

'"TEST" LIKE \'%ha%\''

OLANIYANOLAKUNLE

Thanks Y'all I got the SQL Expression eventually;

arcpy.SelectLayerByAttribute_management("Annos", "ADD_TO_SELECTION",'"TEXTS" LIKE \'%m%\'')

Thanks a bunch!!!!

Please how can i handle the issue of schema Lock? This schema lock issue is really getting on my nerves.

T__WayneWhitley

Well, I guess the shortest answer to combat schema locks is not to have the dataset (the feature class) open in another application.

Things like adding a field I think will require what is called an 'exclusive' lock; other operations may allow what is known as a 'shared' lock. However, it is safe not to allow anything to remain open or any other users accessing your data if you're trying to edit it. (or, if you must allow other users, you may work with versioning, distributed editing, etc.)

Also, if you have done something like open a cursor and you're done with it, that is an object reference you can delete - not sure if that always works in a timely fashion, but it helps to remember if you've opened any object for read/write purposes that it can 'lock' it.

Hope that helps. Is something or some part of your procedure causing the locking of your dataset?

Enjoy,
Wayne

OLANIYANOLAKUNLE

Please which symbol can I use to represent the degree (°) and minute (') symbol in my python scripts, because each time I try to run my script I get this error message for the line containing the 2 symbols mentioned earlier;
\line 32, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details

Any suggestions?

OLANIYANOLAKUNLE

How can i split the text for the ones like this \pt16.25;{\fArial|b0|i0|c0|p34;15.00m} (they have 2 😉 and the script ive been using is like this
arcpy.CalculateField_management("Annos","TEXTS","!TEXTSTRING!.split(';')[1][0:-1]","PYTHON_9.3","")

Please help me

JasonScheirer

You can use regular expressions to take out the control codes in one fell swoop.

import re

def remove_codes(code_string):
    # Get rid of enclosed text, ie {\instruction;Text to keep}
    replaced_sequences = re.sub(r"{\\[^;]+;([^}]*)}", r"\1", code_string)
    # Get rid of standalone \font|22pt; like sequences
    new_string = re.sub(r"\\[^;]+;", "", replaced_sequences)
    return new_string

And this gives us

>>> remove_codes(r"\pt16.25;{\fArial|b0|i0|c0|p34;15.00m}")
'15.00m'

in the Python window

OLANIYANOLAKUNLE

Thanks jscheirer I tried to insert your code into my script and this was the error message I got;

arcpy.CalculateField_management("Annos","TEXTS","!TEXTSTRING!.remove_codes","PYTHON_9.3","")
Runtime error  Traceback (most recent call last):   File "<string>", line 1, in <module>   File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 3128, in CalculateField     raise e ExecuteError: ERROR 000539: Error running expression: "{\fArial|b0|i0|c0|p34;C - 40}".remove_codes  Traceback (most recent call last):   File "<expression>", line 1, in <module> AttributeError: 'str' object has no attribute 'remove_codes'  Failed to execute (CalculateField).

Please what do you think I can do?

JasonScheirer

You put that part with the import and def in the code block and change the expression to remove_codes(!TEXTSTRING!)

RhettZufelt

Please how can i handle the issue of schema Lock? This schema lock issue is really getting on my nerves.

Best way I have found is to have each script spawned in a separate python process. So, I have code similar to the following as my main "control" script:

import os

buildings = r"C:\arcgisserver\python\buildings.bat"
mapping = r"C:\arcgisserver\python\mapping.bat"
MRs = r"C:\arcgisserver\python\MRs.bat"
finish = r"C:\arcgisserver\python\finish.bat"

os.system(mapping)
os.system(buildings)
os.system(MRs)
os.system(finish)

Then, the respective .bat files would be similar to:

cd C:\Python27\ArcGIS10.1

Python C:\arcgisserver\python\buildings.py

Exit

This way, a sepratate python process is spawned to run each script. When it hits the "Exit" in the batch file, it closes that python process and releases ALL lock files. then it moves on to the next script.

Hope this helps,

R_

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.