Hi everyone,
I am confusing how to parse the code like JAP1080-19M to JAP,1080,19,M.(to four-column)
Thanks!
Solved! Go to 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.
Thank you for the reply! Do you know how to remove the dash(-)?
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.
Thanks for your help!