Excel Variables Separation

Help Activities
1

Hello,
I have a comma-separated variable as A,B,C…n in a cell I read from Excel. I want it to repeat the values ​​of A, B,C…n separately for the activities below by defining the variable. I request your help in this matter. Thanks,

1 Like
2

Hey @ridvanucok

You can save that in a variable by creating it from the variables panel to use it later in the activities.

Also, you can save it in a string and use Split function to convert it to an array of characters.

A,B,C…n → [A, B, C, D…, n]

strVal.Split(","c)

Hope this what you are looking for.

Thanks
#nK

1 Like
3

How do I write each value separately after split?

1 Like
4

Hey @ridvanucok

You would storing the split values into an array variable.

arrStr(0)

The above will give you A

arrStr(1)

The above will give you B

and so on.

Hope this helps

Thanks
#nK

1 Like
5

Thank you for your help. :slight_smile:

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.