Skip to main content
Nintex Community Menu Bar

Split filename to be written in columns as metadata

  • February 12, 2020
  • 1 reply
  • 14 views

Forum|alt.badge.img+3

HI, 

I have a requirement where i have a filename i.e. AB123-AB-1101-9000.01. I would like to use the split expression to separate the filename and then write parts of it as metadata. AB123 will be Location, AB will be City code, 1101 will be Door No and 9000 is deisgn code. anything after dot can be ignored. 

 

Can someone adivse?

 

Thanks in advance.

1 reply

Forum|alt.badge.img+8
  • Novice
  • February 12, 2020

Hi,

 

using the Regular Expression Action, you can split your string at the "-"

6454iF8ED3FC81B23C857.png

Store it in a collection variable and access the elements using the Collection Operation Action.

Using pop you can read element by element and update your required fields