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?
@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:
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.
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