Alteryx not Reading "_" character.

If you need to use the REGEX tool in Match mode, I think you'll need to clean up the incoming text before using it in your REGEX. Here's what your example would look like going into your macro, which returns False:

Screenshot 2020-12-03 095724.jpg

Chris

atcodedog05

Hi @vgeetanp

I think the issue was with the regex tool. I am using contains in formula tool.

Here is the modified macro.

Outputs:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

workflow.yxmd

Search Directory For Text in Files.yxmc

Test file.txt

vgeetanp

Thank you @atcodedog05 for your response.

I still face some issue with the macro you shared.

The macro is throwing the result as "True" even if the input does not contain that specific word when there are more than 1 input file in the directory.

I have attached the test file used in the directory for your reference.

If you could assist me on this.. that would be really great 🙂

Thanks in advance.

Test file - 2.txt

Test file.txt

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703