i have a problème. i'd like extract just the rating from 'ratingValue' columns with regex. I tested : (\: \d ..) but the result is : : 8.0. enter image description here

Thank for your help :-)

CodePudding user response：

To match the value of ratingValue:

(?<="ratingValue" : )[\d.] 

This uses a look behind to match (without consuming) the characters preceding what you want to match, then does a simple "digit or dot" match of the number.