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
