Hi I have a property on an event that has this for...
# questions
f
Hi I have a property on an event that has this format of string: #.####x#.#### (for example: 1.123x4.567) Im trying to create a custom property that will be an addition of the right and left number (1.123+4.567=> 5.690) I tried to do it with regex but only got to a rounded number instead of float (6). any idea how to do it? This is what i used: number(REGEX_EXTRACT(property_name,“(.)(?=x)“)) + number(REGEX_EXTRACT(property_name,“(?<=x)(.)“)) *without “number()” it doesn’t add the numbers because it is formatted as string Thanks!