Extracting Numbers from String in Mixpanel Custom Property
In mixpanel custom property, how can I extract 33 from ["33 Min"] string
In mixpanel custom property, how can I extract 33 from ["33 Min"] string
Hi Paritosh d., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To extract "33" from the string "["33 Min"]" in a Mixpanel custom property, you can use a combination of the regex_extract function and the number function. Here's how you can do it:
```
number(regex_extract(properties["Your Property Name"], "\d+", 0))
LBKSLet's break down this formula:
1. `regex_extract`: This function extracts a portion of a string based on a regular expression pattern. In this case, `\\d+` matches one or more digits.
2. `number`: This function casts the extracted string to a number.
Here's what each part does:
- `properties["Your Property Name"]`: This refers to your specific property that contains the "["33 Min"]" string.
- `"\\d+"`: This is the regular expression pattern that matches one or more digits.
- `0`: This argument in `regex_extract` specifies that we want the entire match (not a specific capture group).
The `regex_extract` function will extract "33" as a string, and then the `number` function will convert it to a numeric value.
This approach is based on the information provided in the [Custom Properties Functions documentation](https://docs.mixpanel.com/docs/features/custom-properties#functions-part-2), which describes the `regex_extract` function and its usage.
Remember to replace "Your Property Name" with the actual name of your property that contains the "["33 Min"]" string.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.