Delete text substring from longer text
2338
14
04-02-2019 04:32 PM
by
by
by
by
Maybe you could use regular expressions to replace substrings based on the character index of the first number in the ###.### sequence. Get the index of that character, then use string slices to replace all text between the third character (assuming all the rows start with "NAP") and that index.
Example in ArcGIS Pro using Python:
def replace_substr(s, rte):
import re
# Set pattern to replace beginning section. Optional
# L or R and a space, then 3 numbers, a period, three
# numbers, a space, 1 or 2 letters, and a space.
ptn = re.compile("([LR] )?[0-9]{3}.[0-9]{3} [A-Z]{1,2} ")
# Match the pattern in the string
match = re.finditer(ptn, s)
# Get the first match
m = next(match)
# Get the index where the match started
idx = m.start()
# Create new string by concatenating string slices and route
new_str = s[:3] + rte + s[idx:]
# Set pattern to replace the 'DH ##.###' section
ptn = re.compile("DH [0-9]{2}.[0-9]{3}")
# Replace the 'DH ##.###' section with nothing
new_str = re.sub(" +", " ", re.sub(ptn, "", new_str))
return new_str
by
