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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Classification Builder

Avatar

Community Advisor

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

Avatar

Community Advisor

@Luca_Lattarini - 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.

Avatar

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