I would like the regex expression to remove numbers from text and create a new column with the store number. Below are a few examples.
FHFAberdeen248
FHFAdamsville205
FHFAdel124
FHFAiken61
FHFSoperton1
Solved! Go to Solution.
REGEX_Replace([Field1], '(\d+?)$|.*?', '$1')
Thanks so much!! Big Help
Excellent thanks so much Dan!
Thanks Matthew!