Split text in single line into 4 parts to save in google sheets

How To
,
1

Hi, I’ve got an input text which is always separated by ~~ into always 4 different parts. Each part starts and ends with this separator:“~~”.

Now I want to split these 4 parts using the split function and then map each of the 4 parts to a new row in google sheets.

Any ideas?

Thx a lot in advance :pray:

2

Hello Alfenor,

you do it exactly how you explained it → use the split() function to turn the string in an array, then use the iterator to go through the array and create a new row in a google sheet for each item.

1 Like