Google Sheets - Search row - Pipe Delimited

(Anish Duggal) #1

Within the rows returned with a google sheet search one of the cells contains multiple image urls delimited by a |.

How can I use the first or second or third of the image URL’s within the card image url when sending a card set?

Thanks

(Sarah Palombo) #2

Hi Anish

if you’re returning results something like this

URL.com | URL2.com | URL3.com

you could use the Text Service. The Split Text - action takes your input and breaks it into separate outputs based on a given separator. ( | for instance) . You’d then be able to use Output 1, Output 2, Output 3 in cards

URL.com
URL2.com
URL3.com

Give that a whirl if you get stuck give us a shout :slight_smile:

Sarah

(Anish Duggal) #3

@sarahpalombo

Hi,

Thank you but i think the problem i’m trying to solve is a bit more complicated. I’ve sent a ticket to your support desk about it.

With gratitude.
Anish