Best answer

Extract URL from Slack message giving double URL

  • 13 March 2023
  • 1 reply
  • 124 views

we have a zap that takes a pushed message from Slack, strips out the URL using the Extract URL function in Zapier Formatter & puts the URL into a google spreadsheet. mostly this is working great.

however, for some of the Slack messages, it’s putting the URL twice, with a line between them, like this: https://www.google.com|https://www.google.com.

this is annoying, because then the spreadsheet user can’t click on the link & the heading scraper i have in my spreadsheet won’t work.

i can’t figure out how to fix it. any ideas?

icon

Best answer by Troy Tessalone 13 March 2023, 22:48

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 +14

Hi @AI_hello 

Good question.

You can add a Formatter > Text > Split step and then keep the first segment.