Need help using Regex to extract a value

Hi all,

I need to use regex in bubble to extract the “min_stay” value specific to the date (a dynamic field output by an RG) and have this display in the RG cell text element. Unfortunately, this is not working despite this example working in regex101

Bubble example
https://drive.google.com/file/d/1wl9C6lp9XISTtfT7Ldb46rRyUIC_KxHX/view?usp=drivesdk

Regex 101
https://drive.google.com/file/d/1-ywQz08JPCJHC6MkD0Wiar4P-RseHH5e/view?usp=drivesdk

I’ve followed the instructions using positive lookbehind after grouping didn’t appear to work as seen here: Operators & Comparisons - Bubble Docs

Regex example:
(?<=“26082021”:{
“price”:200,
“user_price”:-1,
“uncustomized_price”:57,
“min_stay”:)\d

Where “26082021” is “Current Cells Date” as seen here:
https://drive.google.com/file/d/1RHGBU-BUluFO_8DYXdNw7eyT-xFWqvr8/view?usp=drivesdk

Example JSON:
{
“26082021”:{
“price”:200,
“user_price”:-1,
“uncustomized_price”:57,
“min_stay”:2
},
“27082021”:{
“price”:300,
“user_price”:-1,
“uncustomized_price”:58,
“min_stay”:3
},
“28082021”:{
“price”:400,
“user_price”:-1,
“uncustomized_price”:59,
“min_stay”:4
},
“29082021”:{
“price”:500,
“user_price”:-1,
“uncustomized_price”:60,
“min_stay”:5
}
}

Does anyone know why this isn’t working or have any other how ideas on how I can extract the min stay value?

This topic was automatically closed after 70 days. New replies are no longer allowed.