How to apply Value() after a Split()

[martinav]

I have a string list of numbers.  I need to split them, and apply Value to it.  Does this have to be done in a ForAll?  

Label38.Text = "1234,4321,2341"

This would be too easy:

Value(Split(TestList,Split(Label38.Text,",")))

How would I do this?

[BCLS776 · Accepted solution]

Yes, since Split() produces a single column table with multiple rows, you will need some way to evaluate each row individually. A ForAll() is a good way to do this.

You can use Concat() to paste the table back into a string later if you like.

Hope that helps,

Bryan