Hey All! I am going crazy over a Regex issue (again). I generally have pretty good luck with Regex but sometimes getting it to work properly in KNIME presents difficulty.
I have a cell this this text on a single line:
[Smith, Jerome (Specialist)], [Smith, Bo (Manager)], [Jones, Joanna (Business Partner)], [Smith, Loretta (Talent Acquisition Partner)], [Jones, Lori (Supervisor)], [Jones, Kristen (Partner)], [Jones, Tina (Partner)], [Diaz, Teodora (Manager)], [Diaz, Kellie (Manager)], [Smith, Christopher (Supervisor)]
I am using this regex (which works fine in RegexPal and Regex 101) in the Regex Split node (Version 4.0)
I just want the “Manager” entries to be split out of the cell into their own cells but for the life of me I cannot get it to work. It will sometimes work if the data is at the front of the line or if there are two entries next to each other. I just don’t know what I’m doing wrong.