Add / in the cell value
Hi Knime community, I want to add “/” after the last letter & before the 1st number in the value for values with DMCOH or DMEUH on it. For ex. my value is “DMEUHARNX110423” format should be “DMEUHARNX/110423” and if the value does not have DMCOH or DMEUH on it then it remains the same. I have the initial string manipulation formula:
regexReplace($CR$, “(DMCOH|DMEUH)(.*)$”, “$1/$2”)
but this one only put the “/” after the DMCOH or DMEUH:
I try other formulas like: regexReplace($CR$, “(DMEUH|DMCOH)([A-Z]+)(\d+)$”, “$1$2/$3”) but its not working on my end.