Save the date! Join us on October 16 for our Product Ops launch event. Register here.
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.
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:
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:
Feb 21, 2023 08:47 PM
Hi @Ron_Daniel ,
Brilliant! Thanks a bunch!