Convert Array

Like (0) Share

Report

Posted on 12 May 2022 09:19:19 by erikgran

Hi, I have following Array

[
 "T223566^T335125^T311000^",
 "Testing1^Testing2^Testing^",
 "First^;^Third^",
 ";^tomorrow^3-D^"
]

And by spltting the list by "^" i want this array as following with

[
 {
 "Row1": "T223566",
 "Row2": "Testing1",
 "Row3": "First",
 "Row4": ";"
 },
 {
 "Row1": "T335125",
 "Row2": "Testing2",
 "Row3": ";",
 "Row4": "tomorrow"
 },
 {
 "Row1": "T311000",
 "Row2": "Testing",
 "Row3": "Third",
 "Row4": "3-D"
 }
]

How do i do this??

/Erik

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

erikgran 18 on 13 May 2022 at 07:38:43

Like (2)

Report

Re: Convert Array

Thank you eliotcole!
Thanks to your input "(I'd imagine that Select actions with a range() function in there will come in to it)" I was able to make it work

Was this reply helpful? Yes No
eliotcole 4,266 Moderator on 12 May 2022 at 10:49:49

Like (1)

Report

Re: Convert Array

I see, thanks.

I don't have time to look at this now, but if no-one else has had a pop (I'd imagine that Select actions with a range() function in there will come in to it) I'll try tonight.

Was this reply helpful? Yes No
erikgran 18 on 12 May 2022 at 10:47:26

Like (1)

Report
Re: Convert Array

Row1, Row2, Row3 and Row4 are always static. I will always have input by set of 4 values.
But I would like the "set" of values to be dynamic.
Another Example
[ "T331992^T344899^", "Example1^Example2^", ";^;^", "Today^tomorrow^" ]

[ { "Row1": "T331992", "Row2": "Example1", "Row3": ";", "Row4": "Today" }, { "Row1": "T344899", "Row2": "Example2", "Row3": ";", "Row4": "tomorrow" } ]

Was this reply helpful? Yes No
eliotcole 4,266 Moderator on 12 May 2022 at 10:39:37

Like (0)

Report

Re: Convert Array

Do you only need to do this once? Or will this be a programmatical approach to future, similar, values?

Was this reply helpful? Yes No