Hi, I am gathering instagram handle’s from a googlesheet.
Then using that handle to search in a trello board.
However some people put the @ sign before their IG handle… like @harriethrose instead of just harriethrose.
This causes issues in the zap finding the card in trello if the card doesn’t have an @ but the row in googlesheets does have an @.
Is there a way to modify the data on the spreadsheet row + column to remove an @ sign?
Best answer by christina.dView original
@Harriet H Rose! Thanks for reaching out and welcome to the community!
I wonder if Formatter by Zapier may work for you here! You may be able to use a Text Formatter step to find the “@” symbol and delete in from that field.
Here’s a few other resources on Formatter in case it’s helpful.
Keep us in the loop! We’d love to know if this works for ya. 🤗