I have a choice column with many values in it
1) 22 - pennsylvania
2) 345 - canada
3) 41 - Atlanta
I want only the numericals from this and the rest can can be ignored (i.e 22 - pennsylvania = 22)
How to use "regular expresstion workflow action" to achieve this
Solved! Go to Solution.
Thankyou so much that worked really well. Here i am storing the output in an Collection variable (eg: 22;55;12), but i need this output for the switch action to run (I cant use a collection variable in switch)
- So i have used a "convert value action" and storing the above collection variable output to a number variable, but i am getting error because its is storing the number with ";" (eg: 22;)
what would you expect from converting a collection to numeric variable???
converting set of/array of multipliple values into single scalar value??? - which one should it take???
you have to run a for ech loop over collection, pick single element from the collection and work with that single element further on (eg. use it in switch)