Derived Properties: Can I use the REGEXEXTRACT function on a cart array property?

I have an array of products (each product being a dictionary of key/value pairs) on cart, checkout and purchase events. I know we can do min/max, add, subtract and other math on these properties, but I am struggling to use the other functions like REGEXEXTRACT to transform values of the products in the arrays. Is this possilbe?

Here's what I have currently, and it generates an error when using in a chart:
REGEXEXTRACT("PROPERTY('Products.primary_category.parents', 'event')", "(\[{name=)[^,]*")

Here's a sample of what the source value look like:

@Mihai_Radu @Mihai Radu @Mihai R

Find more posts tagged with

Derived Properties

Accepted answers

All comments

Amplitude_Admin

Hey there! Thanks for reaching out. Your message has created a ticket in Zendesk, ticket ID: 373348. One of our team members will be reaching out here with more information shortly.

Amplitude_Admin

Hello Dan,
The `REGEXEXTRACT` function is designed to extract substrings that match a specified regular expression pattern from a property. However, when dealing with arrays, especially those containing dictionaries of key/value pairs, the function might not behave as expected if the pattern does not align with the structure of the data.

- **REGEXEXTRACT and other string functions in Amplitude are designed to operate on string properties, not directly on arrays or objects.**
- When you try to use REGEXEXTRACT on an array or object property (such as `Products.primary_category.parents` if it’s an array or object), Amplitude will generate an error because these functions expect a string input, not an array or object
For more detailed guidance on using `REGEXEXTRACT` and other derived property functions, please refer to our Derived Properties documentation https://amplitude.com/docs/data/derived-properties.

Let me know if this helps or if you need more clarification
Best,
B

Mihai_Radu

@dtrubeyweller If your property values are actually strings, I think your approach should work. What do you see in the preview panel below your formula in the Data > Properties > Derived? Does that result in an error as well?

If the property values are dictionaries, then the EXTRACT_FROM_DICT formula should apply: https://amplitude.com/docs/data/derived-properties#object-functions

Amplitude_Admin

status-pending

Quick Links

Unanswered Questions

Anonymous Users to Auth User in Sign Up/Sign In
We're losing user journey tracking when anonymous users switch devices during our sign-up flow. Our typical flow: anonymous user visits homepage on desktop → clicks Sign Up → redirects to Auth0 for registration → user verifies email on mobile (creating a new anonymous user ID) → returns to desktop to complete sign-up and…
Bug: 'Mark all as read' in Alerts not working
Clicking ‘Mark all 7 as read’ is not doing anything to clear my alerts MacBook Air 14-inch M4 macOS: 15.5 Browser: Chrome Version 136.0.7103.114
production houses in islamabad
Reality Beyond Dreams is a team of impact producers. At the heart of every film we produce, and every campaign that we design, are the core principles of Social Impact Entertainment. We are dedicated to creating cinematic projects that promote https://realitybeyonddreams.com/
Best Practices for Switching Amplitude Projects in a Multi-Country Mobile App (Post-Country Selection)
Hi everyone, I’m working on adding Amplitude to a single mobile application serving multiple countries. Inside the app, users are shown a country selector panel (e.g., Egypt, Turkey, UAE, etc.), which determines the localized experience they will receive — each country has its own UX flow and logic. The client wants…
unable to set user property
I have installed Amplitude via Google Tag Manager and looks like the user ID is not being set. I have installed 2 tag from GTM. * Tag type as init * Tag type as setUserId Still say Anonymous user