Splitting string ID code into various partsSplitting string in Python parser of ArcGIS Field Calculator?Select polygons contained inside a polygon and assign IDHow to place points along a line in a specific offset using python / arcpy?Help with formatting ArcGIS text elements with PythonAssigning a vector to a field in feature class (UpdateCursor)Splitting string column into 2 columns in Python?Find the first occurrence of any letter in an alphanumeric stringHow can I convert Bing's “quadtree” tile addresses to ZXY tile addresses in Python?Address Prefix Strip Using PythonOverlay two linestring objects in geopandas, accounting for the attributes

Instead of Universal Basic Income, why not Universal Basic NEEDS?

Define, (actually define) the "stability" and "energy" of a compound

Why did it take so long to abandon sail after steamships were demonstrated?

The use of "touch" and "touch on" in context

Is a lawful good "antagonist" effective?

Is having access to past exams cheating and, if yes, could it be proven just by a good grade?

Make a transparent 448*448 image

Converting Functions to Arrow functions

Does this AnyDice function accurately calculate the number of ogres you make unconcious with three 4th-level castings of Sleep?

Importance of differentiation

At what level can a dragon innately cast its spells?

Meaning of "SEVERA INDEOVI VAS" from 3rd Century slab

Employee lack of ownership

Co-worker team leader wants to inject his friend's awful software into our development. What should I say to our common boss?

Making a sword in the stone, in a medieval world without magic

Ban on all campaign finance?

How to make healing in an exploration game interesting

What has been your most complicated TikZ drawing?

How to answer questions about my characters?

Why are there 40 737 Max planes in flight when they have been grounded as not airworthy?

What are the possible solutions of the given equation?

How to write cleanly even if my character uses expletive language?

Sword in the Stone story where the sword was held in place by electromagnets

What is the greatest age difference between a married couple in Tanach?



Splitting string ID code into various parts


Splitting string in Python parser of ArcGIS Field Calculator?Select polygons contained inside a polygon and assign IDHow to place points along a line in a specific offset using python / arcpy?Help with formatting ArcGIS text elements with PythonAssigning a vector to a field in feature class (UpdateCursor)Splitting string column into 2 columns in Python?Find the first occurrence of any letter in an alphanumeric stringHow can I convert Bing's “quadtree” tile addresses to ZXY tile addresses in Python?Address Prefix Strip Using PythonOverlay two linestring objects in geopandas, accounting for the attributes













1















I have a series of identification codes that I need to split out. The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].



An example of some codes includes S22-201, TT100-12, and V6-1B. Often there is no subdistrict, and all points fall within the same larger district (so no As or Cs or whatever at the end of the string.



I can do parts of it, like splitting at the hyphen.



!Original_ID!.split('-')[0]


and then extracting the district



!Split_ID![1:3]


But it seems like two steps for this are unnecessary, and only works when I know the specific number of characters in the string, which isn't realistic for a large data set.



I'd like to be able to grab each piece at once:



  • letters on the left of the hyphen

  • numbers on the left of the hyphen

  • numbers on the right of the hyphen

  • letters (if any) on the right of the hyphen.

I'd need the numeric fields to be integers (or I guess possibly floats in some rare cases maybe).










share|improve this question









New contributor




vce500 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
























    1















    I have a series of identification codes that I need to split out. The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].



    An example of some codes includes S22-201, TT100-12, and V6-1B. Often there is no subdistrict, and all points fall within the same larger district (so no As or Cs or whatever at the end of the string.



    I can do parts of it, like splitting at the hyphen.



    !Original_ID!.split('-')[0]


    and then extracting the district



    !Split_ID![1:3]


    But it seems like two steps for this are unnecessary, and only works when I know the specific number of characters in the string, which isn't realistic for a large data set.



    I'd like to be able to grab each piece at once:



    • letters on the left of the hyphen

    • numbers on the left of the hyphen

    • numbers on the right of the hyphen

    • letters (if any) on the right of the hyphen.

    I'd need the numeric fields to be integers (or I guess possibly floats in some rare cases maybe).










    share|improve this question









    New contributor




    vce500 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.






















      1












      1








      1








      I have a series of identification codes that I need to split out. The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].



      An example of some codes includes S22-201, TT100-12, and V6-1B. Often there is no subdistrict, and all points fall within the same larger district (so no As or Cs or whatever at the end of the string.



      I can do parts of it, like splitting at the hyphen.



      !Original_ID!.split('-')[0]


      and then extracting the district



      !Split_ID![1:3]


      But it seems like two steps for this are unnecessary, and only works when I know the specific number of characters in the string, which isn't realistic for a large data set.



      I'd like to be able to grab each piece at once:



      • letters on the left of the hyphen

      • numbers on the left of the hyphen

      • numbers on the right of the hyphen

      • letters (if any) on the right of the hyphen.

      I'd need the numeric fields to be integers (or I guess possibly floats in some rare cases maybe).










      share|improve this question









      New contributor




      vce500 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I have a series of identification codes that I need to split out. The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].



      An example of some codes includes S22-201, TT100-12, and V6-1B. Often there is no subdistrict, and all points fall within the same larger district (so no As or Cs or whatever at the end of the string.



      I can do parts of it, like splitting at the hyphen.



      !Original_ID!.split('-')[0]


      and then extracting the district



      !Split_ID![1:3]


      But it seems like two steps for this are unnecessary, and only works when I know the specific number of characters in the string, which isn't realistic for a large data set.



      I'd like to be able to grab each piece at once:



      • letters on the left of the hyphen

      • numbers on the left of the hyphen

      • numbers on the right of the hyphen

      • letters (if any) on the right of the hyphen.

      I'd need the numeric fields to be integers (or I guess possibly floats in some rare cases maybe).







      python arcmap field-calculator






      share|improve this question









      New contributor




      vce500 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      vce500 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited 13 mins ago









      Taras

      2,2342727




      2,2342727






      New contributor




      vce500 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 5 hours ago









      vce500vce500

      62




      62




      New contributor




      vce500 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      vce500 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      vce500 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.




















          2 Answers
          2






          active

          oldest

          votes


















          2














          You're not going to be able to calculate two fields in one go.. though you can split it up into two calcs. I would do this with an update cursor:



          with arcpy.da.UpdateCursor(YourFeatureClass,['Original_ID','District','Split_ID']) as uCur:
          for sRow in uCur:
          OrigID = sRow[0].split('-')[0] # first element in the Original_ID
          charRng = range(len(OrigID)) # a range to iterate over
          Chars = ''
          Numbers = ''
          for Idx in charRng:
          if OrigID[Idx].isnumeric():
          Numbers += OrigID[Idx]
          else:
          chars += OrigID[Idx]
          sRow[1] = float(Numbers)
          sRow[2] = Chars
          uCur.updateRow(sRow)


          This shows how to break up a string into numbers and not numbers and put the values into a row, it should give you some ideas where to start from.






          share|improve this answer






























            1














            Assuming you have four fields, region, district, place and subdistrict already added and you want to use the field calculator to populate them. You would have to run the calculator four times using an expression like:



            Code Block



            import re
            def parse(s):
            """The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].
            An example of a some codes include S22-201, TT100-12, and V6-1B.
            Often there is no subdistrict, and all points fall within the same larger district
            (so no As or Cs or whatever at the end of the string)."""

            letters = re.findall(r'[a-z A-Z]+', s)
            numbers = re.findall(r'[0-9]+', s)

            region = letters[0]
            district, place = [int(n) for n in numbers]
            try:
            subdistrict = letters[1]
            except IndexError:
            subdistrict = None

            return region, district, place, subdistrict


            Then for the region field, use:



            parse(!Original_ID!)[0]


            For district:



            parse(!Original_ID!)[1]


            For place:



            parse(!Original_ID!)[2]


            For subdistrict:



            parse(!Original_ID!)[3]


            However, I would use the update cursor approach suggested by Michael Stimson so you could update all four fields in one hit. Use the following in the python window of ArcMap/ArcGIS Pro:



            import re 
            def parse(s):
            etc... from code block above

            with arcpy.da.UpdateCursor(YourFeatureClass, ['Original_ID','Region', 'District', 'Place', 'Subdistrict']) as rows:
            for row in rows:
            region, district, place, subdistrict = parse(row[0])
            row = [row[0], region, district, place, subdistrict]
            rows.updateRow(row)





            share|improve this answer
























              Your Answer








              StackExchange.ready(function()
              var channelOptions =
              tags: "".split(" "),
              id: "79"
              ;
              initTagRenderer("".split(" "), "".split(" "), channelOptions);

              StackExchange.using("externalEditor", function()
              // Have to fire editor after snippets, if snippets enabled
              if (StackExchange.settings.snippets.snippetsEnabled)
              StackExchange.using("snippets", function()
              createEditor();
              );

              else
              createEditor();

              );

              function createEditor()
              StackExchange.prepareEditor(
              heartbeatType: 'answer',
              autoActivateHeartbeat: false,
              convertImagesToLinks: false,
              noModals: true,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: null,
              bindNavPrevention: true,
              postfix: "",
              imageUploader:
              brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
              contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
              allowUrls: true
              ,
              onDemand: true,
              discardSelector: ".discard-answer"
              ,immediatelyShowMarkdownHelp:true
              );



              );






              vce500 is a new contributor. Be nice, and check out our Code of Conduct.









              draft saved

              draft discarded


















              StackExchange.ready(
              function ()
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f315591%2fsplitting-string-id-code-into-various-parts%23new-answer', 'question_page');

              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              2














              You're not going to be able to calculate two fields in one go.. though you can split it up into two calcs. I would do this with an update cursor:



              with arcpy.da.UpdateCursor(YourFeatureClass,['Original_ID','District','Split_ID']) as uCur:
              for sRow in uCur:
              OrigID = sRow[0].split('-')[0] # first element in the Original_ID
              charRng = range(len(OrigID)) # a range to iterate over
              Chars = ''
              Numbers = ''
              for Idx in charRng:
              if OrigID[Idx].isnumeric():
              Numbers += OrigID[Idx]
              else:
              chars += OrigID[Idx]
              sRow[1] = float(Numbers)
              sRow[2] = Chars
              uCur.updateRow(sRow)


              This shows how to break up a string into numbers and not numbers and put the values into a row, it should give you some ideas where to start from.






              share|improve this answer



























                2














                You're not going to be able to calculate two fields in one go.. though you can split it up into two calcs. I would do this with an update cursor:



                with arcpy.da.UpdateCursor(YourFeatureClass,['Original_ID','District','Split_ID']) as uCur:
                for sRow in uCur:
                OrigID = sRow[0].split('-')[0] # first element in the Original_ID
                charRng = range(len(OrigID)) # a range to iterate over
                Chars = ''
                Numbers = ''
                for Idx in charRng:
                if OrigID[Idx].isnumeric():
                Numbers += OrigID[Idx]
                else:
                chars += OrigID[Idx]
                sRow[1] = float(Numbers)
                sRow[2] = Chars
                uCur.updateRow(sRow)


                This shows how to break up a string into numbers and not numbers and put the values into a row, it should give you some ideas where to start from.






                share|improve this answer

























                  2












                  2








                  2







                  You're not going to be able to calculate two fields in one go.. though you can split it up into two calcs. I would do this with an update cursor:



                  with arcpy.da.UpdateCursor(YourFeatureClass,['Original_ID','District','Split_ID']) as uCur:
                  for sRow in uCur:
                  OrigID = sRow[0].split('-')[0] # first element in the Original_ID
                  charRng = range(len(OrigID)) # a range to iterate over
                  Chars = ''
                  Numbers = ''
                  for Idx in charRng:
                  if OrigID[Idx].isnumeric():
                  Numbers += OrigID[Idx]
                  else:
                  chars += OrigID[Idx]
                  sRow[1] = float(Numbers)
                  sRow[2] = Chars
                  uCur.updateRow(sRow)


                  This shows how to break up a string into numbers and not numbers and put the values into a row, it should give you some ideas where to start from.






                  share|improve this answer













                  You're not going to be able to calculate two fields in one go.. though you can split it up into two calcs. I would do this with an update cursor:



                  with arcpy.da.UpdateCursor(YourFeatureClass,['Original_ID','District','Split_ID']) as uCur:
                  for sRow in uCur:
                  OrigID = sRow[0].split('-')[0] # first element in the Original_ID
                  charRng = range(len(OrigID)) # a range to iterate over
                  Chars = ''
                  Numbers = ''
                  for Idx in charRng:
                  if OrigID[Idx].isnumeric():
                  Numbers += OrigID[Idx]
                  else:
                  chars += OrigID[Idx]
                  sRow[1] = float(Numbers)
                  sRow[2] = Chars
                  uCur.updateRow(sRow)


                  This shows how to break up a string into numbers and not numbers and put the values into a row, it should give you some ideas where to start from.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 4 hours ago









                  Michael StimsonMichael Stimson

                  21.6k22360




                  21.6k22360























                      1














                      Assuming you have four fields, region, district, place and subdistrict already added and you want to use the field calculator to populate them. You would have to run the calculator four times using an expression like:



                      Code Block



                      import re
                      def parse(s):
                      """The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].
                      An example of a some codes include S22-201, TT100-12, and V6-1B.
                      Often there is no subdistrict, and all points fall within the same larger district
                      (so no As or Cs or whatever at the end of the string)."""

                      letters = re.findall(r'[a-z A-Z]+', s)
                      numbers = re.findall(r'[0-9]+', s)

                      region = letters[0]
                      district, place = [int(n) for n in numbers]
                      try:
                      subdistrict = letters[1]
                      except IndexError:
                      subdistrict = None

                      return region, district, place, subdistrict


                      Then for the region field, use:



                      parse(!Original_ID!)[0]


                      For district:



                      parse(!Original_ID!)[1]


                      For place:



                      parse(!Original_ID!)[2]


                      For subdistrict:



                      parse(!Original_ID!)[3]


                      However, I would use the update cursor approach suggested by Michael Stimson so you could update all four fields in one hit. Use the following in the python window of ArcMap/ArcGIS Pro:



                      import re 
                      def parse(s):
                      etc... from code block above

                      with arcpy.da.UpdateCursor(YourFeatureClass, ['Original_ID','Region', 'District', 'Place', 'Subdistrict']) as rows:
                      for row in rows:
                      region, district, place, subdistrict = parse(row[0])
                      row = [row[0], region, district, place, subdistrict]
                      rows.updateRow(row)





                      share|improve this answer





























                        1














                        Assuming you have four fields, region, district, place and subdistrict already added and you want to use the field calculator to populate them. You would have to run the calculator four times using an expression like:



                        Code Block



                        import re
                        def parse(s):
                        """The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].
                        An example of a some codes include S22-201, TT100-12, and V6-1B.
                        Often there is no subdistrict, and all points fall within the same larger district
                        (so no As or Cs or whatever at the end of the string)."""

                        letters = re.findall(r'[a-z A-Z]+', s)
                        numbers = re.findall(r'[0-9]+', s)

                        region = letters[0]
                        district, place = [int(n) for n in numbers]
                        try:
                        subdistrict = letters[1]
                        except IndexError:
                        subdistrict = None

                        return region, district, place, subdistrict


                        Then for the region field, use:



                        parse(!Original_ID!)[0]


                        For district:



                        parse(!Original_ID!)[1]


                        For place:



                        parse(!Original_ID!)[2]


                        For subdistrict:



                        parse(!Original_ID!)[3]


                        However, I would use the update cursor approach suggested by Michael Stimson so you could update all four fields in one hit. Use the following in the python window of ArcMap/ArcGIS Pro:



                        import re 
                        def parse(s):
                        etc... from code block above

                        with arcpy.da.UpdateCursor(YourFeatureClass, ['Original_ID','Region', 'District', 'Place', 'Subdistrict']) as rows:
                        for row in rows:
                        region, district, place, subdistrict = parse(row[0])
                        row = [row[0], region, district, place, subdistrict]
                        rows.updateRow(row)





                        share|improve this answer



























                          1












                          1








                          1







                          Assuming you have four fields, region, district, place and subdistrict already added and you want to use the field calculator to populate them. You would have to run the calculator four times using an expression like:



                          Code Block



                          import re
                          def parse(s):
                          """The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].
                          An example of a some codes include S22-201, TT100-12, and V6-1B.
                          Often there is no subdistrict, and all points fall within the same larger district
                          (so no As or Cs or whatever at the end of the string)."""

                          letters = re.findall(r'[a-z A-Z]+', s)
                          numbers = re.findall(r'[0-9]+', s)

                          region = letters[0]
                          district, place = [int(n) for n in numbers]
                          try:
                          subdistrict = letters[1]
                          except IndexError:
                          subdistrict = None

                          return region, district, place, subdistrict


                          Then for the region field, use:



                          parse(!Original_ID!)[0]


                          For district:



                          parse(!Original_ID!)[1]


                          For place:



                          parse(!Original_ID!)[2]


                          For subdistrict:



                          parse(!Original_ID!)[3]


                          However, I would use the update cursor approach suggested by Michael Stimson so you could update all four fields in one hit. Use the following in the python window of ArcMap/ArcGIS Pro:



                          import re 
                          def parse(s):
                          etc... from code block above

                          with arcpy.da.UpdateCursor(YourFeatureClass, ['Original_ID','Region', 'District', 'Place', 'Subdistrict']) as rows:
                          for row in rows:
                          region, district, place, subdistrict = parse(row[0])
                          row = [row[0], region, district, place, subdistrict]
                          rows.updateRow(row)





                          share|improve this answer















                          Assuming you have four fields, region, district, place and subdistrict already added and you want to use the field calculator to populate them. You would have to run the calculator four times using an expression like:



                          Code Block



                          import re
                          def parse(s):
                          """The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].
                          An example of a some codes include S22-201, TT100-12, and V6-1B.
                          Often there is no subdistrict, and all points fall within the same larger district
                          (so no As or Cs or whatever at the end of the string)."""

                          letters = re.findall(r'[a-z A-Z]+', s)
                          numbers = re.findall(r'[0-9]+', s)

                          region = letters[0]
                          district, place = [int(n) for n in numbers]
                          try:
                          subdistrict = letters[1]
                          except IndexError:
                          subdistrict = None

                          return region, district, place, subdistrict


                          Then for the region field, use:



                          parse(!Original_ID!)[0]


                          For district:



                          parse(!Original_ID!)[1]


                          For place:



                          parse(!Original_ID!)[2]


                          For subdistrict:



                          parse(!Original_ID!)[3]


                          However, I would use the update cursor approach suggested by Michael Stimson so you could update all four fields in one hit. Use the following in the python window of ArcMap/ArcGIS Pro:



                          import re 
                          def parse(s):
                          etc... from code block above

                          with arcpy.da.UpdateCursor(YourFeatureClass, ['Original_ID','Region', 'District', 'Place', 'Subdistrict']) as rows:
                          for row in rows:
                          region, district, place, subdistrict = parse(row[0])
                          row = [row[0], region, district, place, subdistrict]
                          rows.updateRow(row)






                          share|improve this answer














                          share|improve this answer



                          share|improve this answer








                          edited 2 hours ago

























                          answered 2 hours ago









                          user2856user2856

                          30.3k258105




                          30.3k258105




















                              vce500 is a new contributor. Be nice, and check out our Code of Conduct.









                              draft saved

                              draft discarded


















                              vce500 is a new contributor. Be nice, and check out our Code of Conduct.












                              vce500 is a new contributor. Be nice, and check out our Code of Conduct.











                              vce500 is a new contributor. Be nice, and check out our Code of Conduct.














                              Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid


                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.

                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function ()
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f315591%2fsplitting-string-id-code-into-various-parts%23new-answer', 'question_page');

                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

                              How to solve knockout JS error in Magento 2 Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?(Magento2) knockout.js:3012 Uncaught ReferenceError: Unable to process bindingUnable to process binding Knockout.js magento 2Cannot read property `scopeLabel` of undefined on Product Detail PageCan't get Customer Data on frontend in Magento 2Magento2 Order Summary - unable to process bindingKO templates are not loading in Magento 2.1 applicationgetting knockout js error magento 2Product grid not load -— Unable to process binding Knockout.js magento 2Product form not loaded in magento2Uncaught ReferenceError: Unable to process binding “if: function()return (isShowLegend()) ” magento 2

                              Nissan Patrol Зміст Перше покоління — 4W60 (1951-1960) | Друге покоління — 60 series (1960-1980) | Третє покоління (1980–2002) | Четверте покоління — Y60 (1987–1998) | П'яте покоління — Y61 (1997–2013) | Шосте покоління — Y62 (2010- ) | Посилання | Зноски | Навігаційне менюОфіційний український сайтТест-драйв Nissan Patrol 2010 7-го поколінняNissan PatrolКак мы тестировали Nissan Patrol 2016рвиправивши або дописавши її