Fetch particular words from a String

[EN6924]

Hi,

I want to know that is there any Regex logic to select only the Red color marked texts from the records?

[JaeLim]

Hi @EN6924 ,

I do believe you would need 2 different regex logic, as the last 2 rows do not have a consistent pattern with the first 6.

Regex expression for first 6 rows:
.*\s(\w+)

Regex expression for last 2 rows:
.*\s(.*\s\w+)

Hope this helps :) 

[binuacs · Accepted solution]

@EN6924 

[Hayden_McHan]

I do not believe so since when you read in the data from excel to Alteryx, that color formatting will get dropped.

[Qiu]

Agree.
There has been a discussion and come to understand that it seems not possible to bring the formatting of Excel into Alteryx.

[EN6924]

Hi,

It's not about the color. I was trying to extract the texts (Highlighted in red color) from the string records and putting in a new column.

Like-

Input	Output
License Utilization Report	Report
Life Insurance Renewal.	Renewal.
Survey execution complete	complete
India Standard Time	Time
Queries related to previous Incident	Incident
Customer Support Incident	Incident
Running since long time	Running since
Awareness Training Program	Awareness Training

binuacs already did it perfectly, I got the idea now. Thank you so much.