Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 12, 2023 12:36 AM
Hi, 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:
Solved! Go to Solution.
Jul 12, 2023 12:56 AM
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.
Jul 12, 2023 12:56 AM
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.
Jul 12, 2023 01:16 AM
thanks!
Jul 12, 2023 01:31 AM
How do i proceed with this? i tried to
Jul 12, 2023 01:35 AM
REGEX_REPLACE("15.9mm Karet stabil FR RH/LH ES1|05","ES1\|05","")