2 Replies Latest reply on Feb 1, 2017 9:39 AM by Jay Morehart

Regex to match a string after colon ":"

Aleks Roth Dec 25, 2016 6:06 AM

I need to identify a sub string from any string based on a regular expression.

For Example, take the following strings:

1. It sent a notice of delivery of goods: UserName1

2. Sent a notice of delivery of the goods: User is not found, UserName2

3. It sent a notice of receipt of the goods: UserName1

4. It sent a notice of receipt of the goods: User is not found, UserName2

I want to get the text after colon

1. UserName1

2. User is not found, UserName2

3. UserName1

4. User is not found, UserName2

1. Re: Regex to match a string after colon ":"

Mahfooj Khan Dec 25, 2016 9:03 PM (in response to Aleks Roth)

Hi Aleks,

You can try this
Option 1: REGEXP_EXTRACT([String],'[a-z]+\:+(\D+)')
Option 2: MID([String],FIND([String],':',1)+1,LEN([String]))

Let me know If this help.

Mahfooj
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: Regex to match a string after colon ":"

Jay Morehart Feb 1, 2017 9:39 AM (in response to Aleks Roth)

RegExr: Learn, Build, & Test RegEx is a good resource to test regular expressions
Like Show 0 Likes(0)

Actions

Tableau Community