Best answer

Wanting to remove @ from data.

  • 13 October 2022
  • 1 reply
  • 56 views

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?

Thanks

icon

Best answer by christina.d 14 October 2022, 01:14

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +9

Hiya @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. 🤗