This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a body of text. It may contain the name of a color 0-N times. I want to use a lookup table to find the name of a color or colors in the body of text and append the name of the color. In the attached sample workflow, I use a Find/Replace tool set to append.
Here is my problem. The Find/Replace tool only appends the first match. It does not output any matches beyond the first. How do I account for the names of multiple colors?
(The real world list of "colors" is approximately 150 entries. And while the number of colors in the body of text can be 0, that is the exception.)
The procedure here is to split each body into individual words, find the all colors, cross tab them back into one color row per body and join back to the original text. The key to this is adding a recordID at the start to be able to match each individual word and color list back to its original body.