Hello,
I am trying to get a list of values using max_match=5. However I need the results to only return unique values and not just list 5 values regardless of them being duplicates.
| rex max_match=5 (?P<BrandID>(202\d.+?))\"
|table BrandID
Your help and energy is greatly appreciated. 🙂
Thank you,
Spencer Neal
That's not what rex does. It just matches patterns. If you need unique results, then insert the mvdedup function into your query.
```Get all BrandID values```
| rex max_match=0 (?P<BrandID>(202\d.+?))\"
```Filter out duplicate values ```
| eval BrandID=mvdedup(BrandID)
```Keep only the first 5 unique values```
| eval BrandID=mvindex(BrandID, 0 4)
| table BrandID
Rich,
Thank you greatly for taking the time to help me out!! :). Your code did the trick!!
Thank you,
Please take care.
Spencer
If your problem is resolved, then please click the "Accept as Solution" button to help future readers.
That's not what rex does. It just matches patterns. If you need unique results, then insert the mvdedup function into your query.
```Get all BrandID values```
| rex max_match=0 (?P<BrandID>(202\d.+?))\"
```Filter out duplicate values ```
| eval BrandID=mvdedup(BrandID)
```Keep only the first 5 unique values```
| eval BrandID=mvindex(BrandID, 0 4)
| table BrandID