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
20 - Arcturus

@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
20 - Arcturus

@BigDataGeek may be something like this?

 

binuacs_0-1651248653336.png

 

BigDataGeek
8 - Asteroid

That worked perfect, thanks!

Labels