Extract part of a long string

[Alteryx_rookie]

Hi, 

I'm trying to extract part of a string.

The data in the string i something like this:

Name=Tony#Adress=Road#ABC=#Phone=123456789#

How do I extract the phonenumer? Some on the list dosent include a phonenumber and in those cases the number would just be blank like this #phone=#, so the extraction formula should take into account that some of them might not have a phonenumber.

What should the regex formula look like?

[patrick_digan · Accepted solution]

@Alteryx_rookie Something like this in the regex tool worked for me:

#Phone=(.*)#