+4I’m pulling in 10 urls from Zapier in one field. (I can’t seem to split them despite trying the split text formatter)
I have seen some similar formulas to split text but can’t get them to work either.
I need some help so I can separate the URLs out.
+17Hi @Alex_Curtis ,
The easiest way would be to use the Text Formatter - Split Text in Zapier (check screenshot) and choose the Segment index as All(as Separate Fields)
+4Hi @Alex_Curtis ,
The easiest way would be to use the Text Formatter - Split Text in Zapier (check screenshot) and choose the Segment index as All(as Separate Fields)
Hey so this is what I thought would work but all the URLs still come out on one line.
I’ve tried it so many times I’m not sure if it’s because there’s no spaces between the comma
+17Hey so this is what I thought would work but all the URLs still come out on one line.
I’ve tried it so many times I’m not sure if it’s because there’s no spaces between the comma
IF there is no space between the comma then make sure the separator doesn’t have a space after the comma
+4IF there is no space between the comma then make sure the separator doesn’t have a space after the comma
Not sure what’s going wrong
+4
Not sure what’s going wrong
Show’s the outputs when testing the formatter
But can’t add them as separate items into Airtable
+17Show’s the outputs when testing the formatter
But can’t add them as separate items into Airtable
Im sure its a very easy fix, just maybe you didn’t test the formatter after you did the update? Because the results in the 2nd screenshot seems to be Line Items not Separate Fields
+4Im sure its a very easy fix, just maybe you didn’t test the formatter after you did the update? Because the results in the 2nd screenshot seems to be Line Items not Separate Fields
Tested several times, selected seperate fields but output all as Line items, this is why I’m trying to split it in aIrtable.
+4Hey Alex, I’ve put something together here for you to check out that I think does what you need
@Adam_TheTimeSavingCo this looks perfect, I can’t see the formula on the shared view but that’s exactly what I need.
+31@Adam_TheTimeSavingCo this looks perfect, I can’t see the formula on the shared view but that’s exactly what I need.
Hi Alex, you should be able to click “Copy Base” at the top right and add it to a workspace of your own. Once you’ve done that you can view the formulas!
+4Hi Alex, you should be able to click “Copy Base” at the top right and add it to a workspace of your own. Once you’ve done that you can view the formulas!
Hey,
So this works brilliantly, I think there’s an issue with my data as your method works on everything I try except my string of URLs.
First and Second are correct then in Third onwards it adds the first URL.
+31Hey,
So this works brilliantly, I think there’s an issue with my data as your method works on everything I try except my string of URLs.
First and Second are correct then in Third onwards it adds the first URL.
Hm, could you DM me the string of URLs? I’ll see what I can do
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
