Skip to main content

I’m importing a csv and using Files by Zapier and Looping by Zapier to populate a Zapier Table.

One of the columns of the csv includes url’s to images. Instead of there being 1 column per image, all of the image url’s are in a single cell separated by comas.

How can I extract each url into it’s own column in Zapier Tables?

Hey ​@RyanForsythe1979,

To split image URL’s separated by comma, you may wanna use the Split Text functionality in Formatter by Zapier action where you can choose the delimiter as comma. This article can be helpful for this- https://help.zapier.com/hc/en-us/articles/25380258676109-Use-Formatter-to-split-text-in-Zaps#h_01JAG1SPFJBZG83V740CQMP28R

PS: If you need any professional help and want to leverage AI agents and automations for your business, I can help as I am a Zapier Official Silver Solution Partner and you can contact me through my solution page here or just send a DM from my profile :)


Thank you, I’ll give that a try :)


Hi there ​@RyanForsythe1979! How did it go with that Formatter action Sparsh suggested?

Want to make sure you’re all set, so please let us know how if that solved things here 🙂


Hi ​@SamB 

As it turned out I didn’t need it. The Zapier chat bot was able to return all of the images from the table in it’s original format without the need to separate :)

Thanks

Ryan


Thanks for the update ​@RyanForsythe1979, and sorry for the delay in my reply here! I’m so pleased the Zapier Chatbot was able to able to return all of the images as needed so no additional steps were required. 😁

Seems like you’re all good for now, but please do reach back out if you need help with anything else at all. In the meantime, happy Zapping! ⚡