I need to split a filename into variables.
Filename format: BC1234-ECS-xx-xx-bq-a-0011.pdf
Using the [Variable].split("-") gives me and array
How can i replace the " with nothing? and how do I take each element of the array.
I can do [variable].split(2), but that gives the first 2 elements.
I'd normally do something like skip(split(Variable),2),1) which gives the first 2 elements but skips the first. Then wrap a replace('"','') around it.
I can't find how this works in workato.
I forgot to add a screenshoh how I've tried the exclude (which doesn't work yet)
Hi Roland -
I'll answer in two parts -
Send us a ticket, we will try our best to assist you with your problem