Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Classification Builder

1982luca
Level 8
Level 8

Hello everyone,

 

I have a question on Classification Builder. I want to map(filter) all empty value like " " with N/A and map NOT empty value with its value

How can I build the regex?

Thanks

2 Replies
evolytics_brian
Community Advisor
Community Advisor

@1982luca - Classification rules execute in a top-down sequence, with the last rule matched setting the value you see in reports. For example, if a value matches three separate rules, the value set in the third rule is what appears in reports. Based on this, I've had success setting a catch-all rule as the first rule in the list. In your case, it would look something like this:

  • Rule Type: RegEx
  • Match Criteria: .*
  • Set Value To: N/A

This ensures that all values (including empty strings/spaces) are first set to "N/A". If a value matches a subsequent rule, your report will display the value assigned in that subsequent rule. If not other rules are matched, you'll see "N/A" in your reports. Any hits where no value is passed into the prop/eVar will not be assigned classified value.

yuhuisg
Community Advisor
Community Advisor

You could use this RegEx pattern to match an empty string.

^$

^ means match from the start of the string.

$ means match up to the end of the string.

Or you can use the RegEx pattern 

^(?![\s\S])

Reference: https://stackoverflow.com/a/28652413