+9Hi, i have a formula field named "Jenis Parts Regex" where its value is "15.9mm Karet stabil FR RH/LH ES1|05".
I want to extract anything that matches "end_of_name" field, in this case "ES1|05", and the result shall be in "regex replace" field.
But what i got there is "15.9mm Karet stabil FR RH/LH |". Why am i getting "|" ?
Here is my formula in "regex replace" field:
Best answer by Sho
Hi @kennypurnomo ,
In regex, "|" means OR.
So "ES" or "05" is replaced and "|" remains.
If "|" in end_of_name is escaped to "\|", it is treated as a string and can be replaced.
Hi @kennypurnomo ,
In regex, "|" means OR.
So "ES" or "05" is replaced and "|" remains.
If "|" in end_of_name is escaped to "\|", it is treated as a string and can be replaced.
+9How do i proceed with this? i tried to
REGEX_REPLACE("15.9mm Karet stabil FR RH/LH ES1|05","ES1\|05","")
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.