Any advice on String Utils or Regex please?

[Berto2002]

I have the following naming convention for the Telephone Number Asset in the database:

"Telephone DDI - 01702 215761 - Ext 5761"

Sometimes, I just want to refer to the actual number only, "01702 215761"

I just know there is a way to do this and it's likely to be something in Utils but I lack the experience/skill to work it out.

Our consultant on implementation put this in one of our workflows to extract the UserID from the fully-resolved name with ID but I don't really know how it works:

This Expression seems to strip-out everything that is not between the brackets in a string like this: "FirstName SecondName (FirstNameSecondName@org.gov.uk)" and gives the result, "FirstNameSecondName@org.gov.uk"

 

[Ricky]

Hi @Berto2002, Thank you for your post.  You can modify the above regular expression to look for the first -{space} (?<=-\s) and strip out all characters  (.*?) up to the next {space}- (?=\s-).  The full expression would look like the following  (?<=-\s)(.*?)(?=\s-).  

Regards,

Ricky Fearon

Product Specialist

 

[James Ainsworth]

http://regex101.com can be a very useful tool for creating regex expressions.  I've learned a lot using this site.