Regex for Street Address from the Training

Help Studio
1

I’m on the training session “Data manipulation with strings in Studio(v2021.10)” and on section “RegEx Builder”. The video goes over how to build the RegEx as ‘Advanced’ for street addresses but it’s very hard to read and as with other videos it’s hard to tell if parenthesis, curly brackets, or regular brackets are being used.

I can’t find where I can copy and paste the values into the RegEx Value field. Does anyone have a copy of the RegEx value that they would be willing to share? I can see where this would be a very common one to re-use in the future. Thanks!

3

Hi,

Can you share screenshot and/or time of the video?

Regards,

4

@schristenson
Kidly refer to this thread.

5

image
image1920×1080 172 KB

starts at 5:28

6

Thank you! I’ll have to review these.

7

All, I also found this and copied the code and I don’t get syntax errors now for street:

\d+(?:[A-Za-z0-9.-]+?)+(?:Avenue|Lane|Road|Boulevard|Drive|Street|Ave|Dr|Rd|Blvd|Ln|St).?

8

All, I had copied the text but when there were open and closed brackets it created a square so if you’re copying and pasting you’ll want to edit the text if it doesn’t paste properly.

9

Hi,

It’s difficult to read the expression exactly from the video.
How about the following pattern? I tried to write it as similar as video’s one.

\b\d{1,8}(-)?[a-z]?\W?[a-z]?\W.{1,}\W(road|drive|avenue|boulevard|curcle|street|lane|way|rd\.|st\.|dr\.|ave\.|cir\.|ln\.|rd|dr|ave|blvd|cir|ln)

Regards,

10

Thank you! We ended up switching to do the StudioX training as we are a low code/no code team so I am now diving into that training. When I have time I’ll try your regex in Studio. Thank you for providing it!