topic Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA in Python Questions

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

OLANIYANOLAKUNLE — Thu, 23 May 2013 20:57:50 GMT

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

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

RhettZufelt — Thu, 23 May 2013 22:56:40 GMT

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_

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

ChrisSnyder — Thu, 23 May 2013 23:24:17 GMT

"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","")

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

Anonymous User — Fri, 24 May 2013 00:00:13 GMT

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

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

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

OLANIYANOLAKUNLE — Fri, 24 May 2013 12:35:16 GMT

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

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

OLANIYANOLAKUNLE — Fri, 24 May 2013 12:48:16 GMT

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

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

T__WayneWhitley — Sun, 12 Dec 2021 00:00:51 GMT

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'
>>>

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

OLANIYANOLAKUNLE — Fri, 24 May 2013 13:40:49 GMT

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.

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

T__WayneWhitley — Sun, 12 Dec 2021 00:00:54 GMT

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.)

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

OLANIYANOLAKUNLE — Fri, 24 May 2013 14:14:33 GMT

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.

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

T__WayneWhitley — Fri, 24 May 2013 14:27:31 GMT

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]

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

OLANIYANOLAKUNLE — Fri, 24 May 2013 14:41:34 GMT

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

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

T__WayneWhitley — Fri, 24 May 2013 14:56:16 GMT

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

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

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

OLANIYANOLAKUNLE — Fri, 24 May 2013 22:25:52 GMT

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.

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

T__WayneWhitley — Fri, 24 May 2013 22:57:18 GMT

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

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

OLANIYANOLAKUNLE — Sun, 26 May 2013 11:41:33 GMT

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?

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

OLANIYANOLAKUNLE — Sun, 26 May 2013 15:26:27 GMT

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

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

JasonScheirer — Sun, 12 Dec 2021 00:00:57 GMT

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

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

OLANIYANOLAKUNLE — Sun, 12 Dec 2021 00:01:00 GMT

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?

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

JasonScheirer — Mon, 27 May 2013 10:48:43 GMT

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