Split filename to be written in columns as metadata

[Kammasood]

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.

[Tarf · Accepted solution]

Hi,

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

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