regex parse help

[556891a]

Hi everyone,

I am confusing how to parse the code like JAP1080-19M to JAP,1080,19,M.(to four-column)

Thanks!

[ggruccio · Accepted solution]

Hi @556891a,

I'm not the most efficient Regex coder, so I often divide it into small tasks...using the Regex tool multiple times and pulling out expressions using "Tokenize" where patterns match.

See the attached workflow below, which will generate this output.

[556891a]

Thank you for the reply! Do you know how to remove the dash(-)?

[ggruccio]

Hi @556891a ,

Yes, was an oversight on my part.  I removed a period in front of the \d\d that I was using to capture that hypen.  Should be all good now.   Please see the attached revised workflow.

[556891a]

Thanks for your help!