Skip to main content
Best answer

Wanting to remove @ from data.

  • October 13, 2022
  • 1 reply
  • 207 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

Best answer by christina.d

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

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

christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • Answer
  • October 13, 2022

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