Skip to main content
Solved

Regex Formula for This Pattern

  • February 21, 2023
  • 2 replies
  • 29 views
H
Forum|alt.badge.img+18

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

Best answer by Ron_Daniel

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:

VALUE(REGEX_EXTRACT({Orig value}, "Date\\((\\d+)\\+0000\\)", 1))

If those last four change, then use:
VALUE(REGEX_EXTRACT({Orig value}, "Date\\((\\d+)\\+\\d{4}\\)", 1))

Hope that helps!
- Ron

2 replies

Ron_Daniel
Forum|alt.badge.img+21
  • Ron_Daniel
  • Inspiring
  • Answer
  • February 21, 2023

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:

VALUE(REGEX_EXTRACT({Orig value}, "Date\\((\\d+)\\+0000\\)", 1))

If those last four change, then use:
VALUE(REGEX_EXTRACT({Orig value}, "Date\\((\\d+)\\+\\d{4}\\)", 1))

Hope that helps!
- Ron
H
Forum|alt.badge.img+18
  • Hendrik_Yang
  • Author
  • Inspiring
  • February 22, 2023

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:

VALUE(REGEX_EXTRACT({Orig value}, "Date\\((\\d+)\\+0000\\)", 1))

If those last four change, then use:
VALUE(REGEX_EXTRACT({Orig value}, "Date\\((\\d+)\\+\\d{4}\\)", 1))

Hope that helps!
- Ron

Hi @Ron_Daniel ,

Brilliant! Thanks a bunch! 

Ron_Daniel
Terms & ConditionsAccessibility statement