cancel
Showing results for 
Search instead for 
Did you mean: 
PSSRK
Nintex Newbie

Regular expression action

Jump to solution

I have a choice column with many values in it

example:

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

 

Thankyou

Labels: (1)
0 Kudos
Reply
4 Replies
Automation Master
Automation Master

Re: Regular expression action

Jump to solution

eg.

 

^\d+(?=\ -)

 

 

i.jpg

0 Kudos
Reply
PSSRK
Nintex Newbie

Re: Regular expression action

Jump to solution

Emha,

 

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: 22Smiley Wink 

 

0 Kudos
Reply
Automation Master
Automation Master

Re: Regular expression action

Jump to solution

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)

 

0 Kudos
Reply
metitad2009
Nintex Newbie

Re: Regular expression action

Jump to solution

I want to convert file extension of Excel document from .xls to.xlsx which is found in a document library. Any suggestion on this?

0 Kudos
Reply