Hi,
I want to know that is there any Regex logic to select only the Red color marked texts from the records?
Solved! Go to Solution.
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 :)
I do not believe so since when you read in the data from excel to Alteryx, that color formatting will get dropped.
Agree.
There has been a discussion and come to understand that it seems not possible to bring the formatting of Excel into Alteryx.
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.