Hi all, my webhook (from trello) is sending simple data but for some reason it’s including an invisible character called “(a Word Joiner, U+2060)” which is not allowing google sheets to return any matching results. I tried using the “replace” function and text parser with no luck. I’m worried the Make modules do not recognize these invisible characters! See blueprint and images
Hello @Mitch_Silverman,
Have you tried using the ascii function around your search term?
The ascii() function removes all non-ascii characters from a text string.
Hi thanks again. Can you help me with one more thing: The “Contains” search module in google sheets has to find an exact match? When the system searches for 4415 and I have a cell with 44-15 shouldn’t it return that row? right now it is not returning anything thanx @Donald_Mitchell
