Highlight specific text in table reporting

[terrellchong]

Hi all,

I would like to highlight specific item in reporting. 

I can only use table as I have other things need to merge it into one place

Can alteryx do this specific task?

[binuacs · Accepted solution]

@terrellchong You can play around the attached workflow

[atcodedog05]

Hi @terrellchong 

An amazing method by @binuacs 

Here is my take a slightly modified version of @binuacs workflow.

Workflow:

Output:

Hope this helps : )

[Qiu]

@terrellchong 
Nicely done!

[terrellchong]

Hi @binuacs , @Qiu , @atcodedog05 ,

I am thinking of something that is like this at the moment into the formula 

REGEX_Replace([Table], "<.*>", '<span style="color:RED"><u>'+ +'</u></span>')

As the letter inside the <> will change over time, its best to use a regex to sort of find the < and >, then replace the thing that you guys just posted.

[atcodedog05]

Hi @terrellchong 

Yes but you need to know and pass the pattern of text that needs to be highlighted.

Hope this helps : )

[atcodedog05]

Happy to help : ) @terrellchong 

If our response helps please don't forget to mark it as solution.

Cheers and have a nice day!

[terrellchong]

Yes, but I am currently stuck at bringing the found pattern text to replace it using regex...

[atcodedog05]

Hi @terrellchong 

Share us the pattern and sample data we can help you out.

Happy to help : )

[terrellchong]

Hi @atcodedog05 ,

Please find the workflow attached, which the screenshot of expected result.