Hi all, I'm still learning the regex tool and i'm struggling with something that is really simple: i have this: addressreg ex out 1reg ex out 2 12 bobton lane12bobton lanelevi lane levi lane i cant seem to get the right expression to show both examples ? could someone be so kind to explain how to split those out? - i'm sure its simple i'm just not writing the expression correctly

Reg Ex tool Parse

Hi all,

I'm still learning the regex tool and i'm struggling with something that is really simple:

i have this:

address	reg ex out 1	reg ex out 2
12 bobton lane	12	bobton lane
levi lane		levi lane

i cant seem to get the right expression to show both examples ? could someone be so kind to explain how to split those out? - i'm sure its simple i'm just not writing the expression correctly

Expression

Accepted answers

DataNath

How does this look @berty? Because both of the addresses don't have a number element, even though you want to split that out if present, I've just made that capture group optional with the ? notation. By the way, this assumes the same address formats so let me know if they can differ or if this doesn't work when applied to a wider dataset and can look to amend it.

(\d+)?\s?(.+)

Parse address with optional number.yxmd

DataNath

Hey @berty no worries - thanks for the example! Give this a try and again let me know if you come across any further issues

([0-9-]+)?\s?(.+)

Parse address with optional number - Updated.yxmd

All comments

Amol_Telore

Hey @berty

Here is my solution. Let me know in case of any concerns.

New Workflow3.yxmd

DataNath

(\d+)?\s?(.+)

Parse address with optional number.yxmd

berty

@DataNath - this was perfect, i just found a little issue that I'm not sure how i configure this..

i have this address 77-79 yardman close and it seems to split like this

77-79 yardman close

-79 yardman close

how can i get -79 added to field showing 77?

DataNath

Hey @berty no worries - thanks for the example! Give this a try and again let me know if you come across any further issues

([0-9-]+)?\s?(.+)

Parse address with optional number - Updated.yxmd

Amol_Telore

@berty Adding to @DataNath solution, I have created below regex code in case you get other character as well such as space or underscore in lane number. It will dynamically capture those details.

(.+\d\b)?\s?(.+)

1. First capturing group : it will match everything till boundary of last digit. In this case it will be 77-79

2. Second capturing group : it will match remaining part as lane name.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703