Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Add html string before and after a word found in list?

BigDataGeek
8 - Asteroid

Hi,

 

I've been working on a way to find specific words from a specific list in another list.   @NicoleJohnson and @danilang  found a great solution (attached) for that.  Now I'd like to add HTML before/after the word where it's found so it highlights in a powerapp.  Something like :

 

<span style="background-color: #FFFF00">Word</span>

 

Given the solution attached, what would be the easiest way to add this to the existing input fields where it's found?

5 REPLIES 5
BigDataGeek
8 - Asteroid

In the example above, I'd want the html wrapped around the word in 'Field 1'.

 

 

BigDataGeek_0-1651204151174.png

 

 

 

binuacs
21 - Polaris

@BigDataGeekare you looking some thing like below

 

binuacs_0-1651213410506.png

 

BigDataGeek
8 - Asteroid

I'm looking to update the field where the word is found, so if it is found in field 1 or field 2, it would update that field by added the html around the word found. 

binuacs
21 - Polaris

@BigDataGeek may be something like this?

 

binuacs_0-1651248653336.png

 

BigDataGeek
8 - Asteroid

That worked perfect, thanks!

Labels
Top Solution Authors