
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 21, 2023 01:00 AM
Hi Guys,
I am trying to wrap my head around regex formula but can't figure out what if there are two patterns in the string. Basically I want to extract the number after the bracket but before the "+".
Current value : /Date(1676537746330+0000)/
Desired value : 1676537746330
Thanks
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 21, 2023 01:02 PM
Hi @Hendrik_Yang ,
You didn't mention whether the last four digits are always 0000, but here it is both ways:
If always 0000, then the formula is:
If those last four change, then use:
Hope that helps!
- Ron

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 21, 2023 01:02 PM
Hi @Hendrik_Yang ,
You didn't mention whether the last four digits are always 0000, but here it is both ways:
If always 0000, then the formula is:
If those last four change, then use:
Hope that helps!
- Ron
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 21, 2023 08:47 PM
Hi @Ron_Daniel ,
Brilliant! Thanks a bunch!
