Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
I forgot about the cleaning of the numbers though. Good point. I used the contains function to find the search in the complained, think that worked a bit easier than splitting every word.
I think the directions were a little confusing. I was originally looking for the counts of those in each of the records, not just flagging if the record had the word. But figured it out.
Basically it is possible to do it using Find Replace tool, bet for some reason this tool is doing search in first 250 characters. I don't know why. So there is workaround.