Hi everyone,
I am confusing how to parse the code like JAP1080-19M to JAP,1080,19,M.(to four-column)
Thanks!
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(-)?