Forum Discussion
Need help with Regex
Thank you very much, much appreciated bob , the reegx helps to identify the product in the string, which is great but the challenge when there are multiple products i.e. account numbers listed in the string. Don't think I can use the filter starts with 'o' as the target attribute account_active is a custom attribute and not within a nested object (in which case I could have used multi-criteria segmentation where account_active starts with 'o' AND matches regex ^o[a-z]{3}-[0-9A-Z]{8,10}$
Cheers
Raj
Okay, ignore any simple starts-with/contains filters.
I thought you only wanted to match when there was a single identifier in the string, so no multiple values and no comma-separation?
"...need only that user that has got only one account starting with "o" and they should not have any other account numbers."
In which case, the ^ at the start will ensure that the following character occurs at the beginning of the string and the $ at the end will ensure that there's nothing after the preceding matched characters - which in this case are specific enough to only match a single account number.
- Rajorigin9 months agoSpecialist
Hello again bob , the first SS is my filter to match the regex and the second one is one of the users I previewed in the output. You can see there are 3 active accounts for the user and therefore doesn't match my criterion.
- bob9 months agoSpecialist
Wow, that makes no sense.
I've tested this, just in case the docs and my memory were wrong, and ^ and $ absolutely do work in this context to match beginning and end of string.
Did this custom attribute have it's type confused? Was it an array at some point and now it's a string?
Related Content
- 7 months ago
- 2 years ago
- 27 days ago