How to index particular value from cell excel

Learning Hub Academy Feedback
1

Hi all,

I have this excel
test.xlsx (9.4 KB)
and in cell I have this value “abc, def, xyz, mnp”.
I would calculate the position of “,”.
I used this formula: “myVariable.IndexOf(”,“).ToString” in for each but I calculate the same position, instead how could I calculate the other position of commas?

How can I do?
testIndex.xaml (10.6 KB)

Could you help me?

Regards,
S.

2

Hi @salvatore.quimi

You can try this approach

image
image753×477 18.2 KB

Xaml for reference

CommaIndex.xaml (6.9 KB)

3

Hi @kumar.varun2,

thank you for your solution, but I have seen that CommandIndexArr is an array, I would need to calculate the positions individually, for every time it enters in the for each, example:
1 time
myVariable = 3
2 time
myVariable = 8
3 time
myVariable = 13

Could you support?

Regards,
S.

4

Hi @salvatore.quimi

I have done some modification. Please check

CommaIndex.xaml (8.4 KB)

5

It works!!!
Thank you for your support

1 Like
6

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