Forum Discussion
Extract Address from Cell Text
Background: I'm working with address data that uses the quadrant system (ends with NW, NE, SW, or SE). There are only very few instances where it ends with N or S. I have a column of data that...
Playtime! OK, I confess this is not my forte, but here is a start at a regular expression but with the regex hidden.
all and compassPts are just defined names that return text. PosLookAhd is a Lambda function.
posLookAhd = LAMBDA(x,"(?=" & x & ")" )
Such a function is not exactly in the spirit of REGEX! ... but kind of fun.
Thanks so much! You introduced me to topics (Parameter Query and Regular Expression) I didn't even know existed, and once I develop a better understanding, I can hopefully modify them for my uses.
