I am a total regex newbie trying to use regex to help clean up an address file. The file (exported from Endicia) has company names mixed in with addresses in the same field.
All the addresses begin with digits, so I’d like to either select all the records that begin with letters [A-Z] or alternately all the records that begin with digits. Searching online I see the carat ^ used to match the beginning of a string in regex but that doesn’t seem to fly in Panorama.
While it might be nice to learn to use regular expressions, you do not need to for this. Just look at the first letter of the field and select those which are between “1” and “9”, assuming that no address begins with 0. That should be a search on strings, not values.
There never was an answer that I can see on how to search with Regex. There are examples of how to search a block of text, but what about searching a database?
How would I apply Regex 800|801|802 to find Denver zip codes in a field of zip codes?
Right you are. I was hurrying to put together a simple Regex example, and I had some doubts about my accuracy. It made the point though, helped me learn a touch more, showed the right way to do a search, and left an example for others down the road. Thanks, David.
I’m just learning to swim in Regex and have immediately been thrown into an ocean of it. It’s worth mentioning that your movie, Introduction to Regular Expressions, in the Panorama X Video Training is a very helpful introduction.
I’m definitely not a Regex expert. But the basics are really not that complicated. I think most Regex books and tutorials try to explain too much way too fast, I tried to avoid that in the video you mentioned. There’s a lot you can do with just about a dozen simple regex elements.