CODEWITHSUNDEEP
regexopenrefine
Lara M.
Lara M.

Reputation: 855

Openrefine, match text inside parentheses

I'm having cells like

10 (1880 15) ; 11 (1880 15) ; 12 (1880 15) ; 7 (1880 15) ; 3 (1880 15) ; 9 (1880 15) ; 2 (1880 15) ; 1 (1880 15) ; 4 (1880 15) ; 5 (1880 15) ; 6 (1880 15) ; 8 (1880 15)

and I want to take all the text inside the parentheses. Using this expression it gives me a Null result: 

value.match(/\(.*?\)/)

Why that? Thanks

Upvotes: 1

Views: 420

Answers (1)

Ettore Rizza
Ettore Rizza

Reputation: 2830

The match function does not work as you think. It is very counter-intuitive. That's why since Open Refine 3 there is a find function that does exactly what you want. 

value.find(/\(.*?\)/)

enter image description here

Upvotes: 3

Related Questions