Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Highlight specific text in table reporting

terrellchong
8 - Asteroid

Hi all,

 

I would like to highlight specific item in reporting. 

terrellchong_2-1644993199338.png

 

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

 

Can alteryx do this specific task?

 

 

11 REPLIES 11
binuacs
17 - Castor

@terrellchong You can play around the attached workflow

 

binuacs_0-1644998118678.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @terrellchong 

 

An amazing method by @binuacs 

 

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

 

Workflow:

atcodedog05_0-1644998781327.png

 

 

Output:

atcodedog05_1-1644998811416.png

 

Hope this helps : )

Qiu
19 - Altair
19 - Altair

@terrellchong 
Nicely done!

terrellchong
8 - Asteroid

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
22 - Nova
22 - Nova

Hi @terrellchong 

 

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

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @terrellchong 

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

Cheers and have a nice day!

terrellchong
8 - Asteroid

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

atcodedog05
22 - Nova
22 - Nova

Hi @terrellchong 

 

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

 

Happy to help : )

terrellchong
8 - Asteroid

Hi @atcodedog05 ,

 

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

terrellchong_0-1645061978060.png

 

Labels