Skip to main content
Nintex Community Menu Bar

Regular expression action

  • March 27, 2019
  • 4 replies
  • 16 views

Forum|alt.badge.img+3

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

4 replies

Forum|alt.badge.img+14
  • Scholar
  • March 27, 2019

eg.

 

^d+(?= -)

 

 

1208i45937A73756B267B.jpg


Forum|alt.badge.img+3
  • Author
  • Rookie
  • March 27, 2019

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: 22;) 

 


Forum|alt.badge.img+14
  • Scholar
  • March 28, 2019

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)

 


Forum|alt.badge.img

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