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

Split field on first number

DanielAmrine

Edit (by Xander Bakker): the original question was placed at this thread: Extracting an integer from a string field but I decided to branch it to a new thread.

I have a similar situation...

For Example:

s ="POWERS 1C-23HZ"

and some are like s2 = RATTLER4C-34HZ

I would like to tell python to find the first number in each field and then split the field at the same location at the first number. so....

Field 1 = RATTLER

Field 2 = 4C-34HZ

derived from the string above: s2

I would like to use the field calculator to do this.

I know you can use this to split on the space:

!field! = s.split(' ')[0]

I did this in the field calculator expression box and it works but only on the strings with a space where I need to break it.

Any help is much appreciated!

Dan A.

Message was edited by: Xander Bakker. Post branched to new Thread

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

Accepted answers

XanderBakker

A small addition to the code contributed by Darren. In the example "POWERS 1C-23HZ", your first result will include "POWERS " with the space included. If any space at the beginning or end should be stripped, you can use something like this

a = "POWERS 1C-23HZ"
for i in range(len(a)):
  if a.isdigit():
      b = [a.strip() for a in [a[:i],a]
      break
print b

#  ['POWERS ', '1C-23HZ']

If you want to use this in the field calculator and fill two fields with it, you must remember that a Field Calculation can only write to a single field per run. Does than mean that you need two functions to implement what you want? No, not really. You can work with an additional parameter (index) that will extract the value you want.

The code block could be something like:

def SplitAtDigit(a, index):
    try:
        found = False
        for i in range(len(a)):
           if a.isdigit():
               b = [a.strip() for a in [a[:i], a]
               found = True
               break
        if found:
            return b[index]
        else:
            if index==0:
                return a
            else:
                return ''
    except:
        return ''

and you can use these settings:

for the first field and:

SplitAtDigit( !infield!, 1)

...for the second field. This will result in:

All comments

XanderBakker

Can you post a sample of your data? What is the error you obtain?

You should't have any problems with the indentation, but I can create an expression file that you can load.

DanielAmrine

Xander et al...

This is the code i entered into the code block:

def SplitAtDigit(a,index):
    try:
        found = False
        for i in range(len(a)):
           if a.isdigit():
               b = [a.strip() for a in [a[:i], a]
               found = True
               break
           if found:
               return b[index]
           else:
                if index ==0:
                    return a
                else:
                    return ' '
    except:
           return ' '

and then:

SplitAtDigit( !field!,0)

unfortunately all it does is copy one field into the new field without splitting the original text string.

i have compared this with what you posted many times and it took me several tries to get the indentation right. i know from the table you posted it worked for you, so I son't understand why it isn't working for me.

All fields i'm using are text fields and i don't see anything else that would keep this from working.

the only other problem i can think of is that some of strings in the original text column have multiple spaces before the first number.

Let me know if there is anything jumping out at you in this block of code.

Dan

DanielAmrine

I apologize

I should of started a new post but i don't think people would have seen or replied to it as quickly if i had done that!

Thank you all for the ideas. I realize now i will have to do one field at a time if i use the calculator.

Thank you Xander for laying it out like you did....it was very helpful.

Dan

DanPatterson_Retired

Xander, good thing you branched it , poor Phil is probably wondering about the emails he is going to get tomorrow morning on a 3 year old thread

XanderBakker

a = "POWERS 1C-23HZ"
for i in range(len(a)):
  if a.isdigit():
      b = [a.strip() for a in [a[:i],a]
      break
print b

#  ['POWERS ', '1C-23HZ']

The code block could be something like:

def SplitAtDigit(a, index):
    try:
        found = False
        for i in range(len(a)):
           if a.isdigit():
               b = [a.strip() for a in [a[:i], a]
               found = True
               break
        if found:
            return b[index]
        else:
            if index==0:
                return a
            else:
                return ''
    except:
        return ''

and you can use these settings:

for the first field and:

SplitAtDigit( !infield!, 1)

...for the second field. This will result in:

blake.terhune

How about something like this?

s ="POWERS 1C-23HZ"
s2 = "RATTLER4C-34HZ"
for string in (s, s2):
    string = string.replace(" ", "")  ## Drop spaces (optional)
    print string
    string_builder = ""
    field_vals = None
    for i in string:
        if i.isdigit():
            field_vals = (
                string[:len(string_builder)],  ## string before number
                string[len(string_builder):]  ## string after number
            )
            print field_vals
            break
        else:
            string_builder += i

I am not clear on how you want to use field calculator to write to two output fields, so I'll let you clarify your intent or adapt this logic to your specific need. You'll at least need to get rid of the first three lines.

EDIT: Xander and Darren beat me to it!

DanPatterson_Retired

Darren is right, his is probably easier to understand... but for continuity

>>> a = "RATTLER4C-34HZ"
>>> b = a.split("-")[0][-2]
>>> b
'4'
>>> c="4"+a.split("4",1)[1]
>>> c
'4C-34HZ'

The number after the "4" is the maximum number of times to split the string, incase you have more than one four, which you do

DarrenWiens2

>>> a = "RATTLER4C-34HZ"
... for i in range(len(a)):
...    if a.isdigit():
...        b = [a[:i],a
...        break
... print b
...
['RATTLER', '4C-34HZ']

DanPatterson_Retired

>>> a = "RATTLER4C-34HZ"

>>> b=a.split("-")[0][-2]

>>> b

'4'

Připojte se k diskusi

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.