Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I would like to count fields with non-alphanumeric characters, using set analyses (not in the load script).
i.e. if contains non-alphanumeric characters.
Does anyone know how to do this please?
It's not quite clear for me if you want to count fields or fieldvalues. Counting fields within the UI without support from any script-measures will be rather difficult to impossible. Measuring to fieldvalues should be possible with set analysis, for example with something like:
count({< YourField = {"=len(purgechar(YourField, '012..abc..XYZ'))>0"}>} YourField)
- Marcus