AnsweredAssumed Answered

Extract particular values from field

Question asked by CCweedcontrol on Mar 6, 2020
Latest reply on Mar 12, 2020 by CCweedcontrol

I need help with extract a particulate value from the field "PojectIinfo" field.  I need to only extract the value/characters of the letter B and the 10 digits after the B an place it in the field "BP".

There might be a space in that value as well, for example B24501000 space 0. The total characters would be 11; B plus 10 digits. I am thinking i need to use re.compile but i am uncertain on the code.



Current field looks like this.


New SFR w/Attached Garage, covered parch and patio B24501000 0  >>>Extract B24501000 0 to BP field

B34567000 0 30 X 48 Pole Barn >>>Extract B34567000 0 to BP field

NEW 22,778 SQ FT B33561000 0 Addition to existing hop building >>>Extract B33561000 0 to BP field

Residential B14356000 0 Storage>>>Extract B14356000 0 to BP field