How would you split up a text string into 3 values that can then be used in a SC?

[mgaussie]

Hey all,

I have an address line, e.g. San Francisco, California, United States.

I’d like to split the string up so each split is useable as a variable in a Server Action.

I’ve tried split string in a set value, setting it as text and as an array but don’t seem to be returning anything more than the same string in output in dev tools.

I’ve checked this post out thinking it might solve my need, but couldn’t find a solution here:

Text to array using split

Hello, This one is very tricky. I’ve got a text I get from an API, so I realized that for better filtering of the text I receive I need to split the text using regex (/\n/). I need to create a multi insert in my server action that takes the value “text” splits it and the insert each value to my database. I’ve got this: [image] Of course, didn’t work because the value I set (SplitText) is an array without any text inside it, I need to insert the new split text into my database.

I’ve also tried doing it on the front end - with ‘split’ in the text formatter, but I’m missing the part (which is no doubt obvious) that would enable me to return the three items from the string.

Will keep playing around but appreciate anyone pointing me in the right direction.

[mebeingken]

Split creates an array, so you should be able to get at the individual items using the index for each.

For example, the first item is:

$_POST.ac_input.split(',')[0]

[mgaussie]

Hey Ken!

I was looking at the output and it only returned a single result, instead of [0] San Francisco [1] California [2] United States which would be as expected - if the split / array worked correctly this would display as such in dev tools?

[mebeingken]

Sorry, not understanding your last comment.

[mgaussie]

As the output in dev tools, I would expect it to display:

[0] San Francisco
[1] California
[2] United States

If it did then your solution would work perfectly.

But the output in dev tools is just displaying: [0] San Francisco, California, United States

Which leads me to believe that it’s not splitting the text?

[mebeingken]

You used exactly what I provided?

[mgaussie]

Got it! It didn’t like the space, I was trying to split with the ', ’ instead of just ‘,’ like you wrote.

I’ll do another formatter to get rid of the space and should be good to go. Thank you!!

[mebeingken]

Sorry, I forgot to call out that change I made when adding the index.