
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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:
Please help
Thanks
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 12, 2023 01:16 AM
thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 12, 2023 01:31 AM
How do i proceed with this? i tried to
But the result is this

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 12, 2023 01:35 AM
REGEX_REPLACE("15.9mm Karet stabil FR RH/LH ES1|05","ES1\|05","")
