Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Find and Replace Tool - Finding at beginning of field instead of any part

jaypee1217
7 - Meteor

I kept trying to figure out why my find and replace wasn't working. I confirmed string type, no trailing or leading whitespaces from source file or in my replace file, etc. Finally I realized that the only 2 that were failing from my entire list were text that was in the middle of my source field. As a test I moved the word to the beginning of the field, then it worked. But my option is set to Any Part of Field, not case sensitive and not matching whole words. 

 

I'm not sure why. 

jaypee1217_1-1682010653006.png

 

 

 

jaypee1217_0-1682010299787.png

 

1 REPLY 1
StellaBon
11 - Bolide

If you think you configured it right but it's not working as intended you could report it as a bug.

Labels
Top Solution Authors