Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Just want to know if there is any way to exclude the field which contained character '*'.
I have tried the following but not luck.
count({<FieldA={"*"}-{"**"}>} id)
Anyone have any idea?
Best Regards,
Karl
To work around the problem of the * being misinterpreted as a wildcard, I would use the set search argument:
{"=index(FieldA,'*')>0"}
Then the exact syntax depends on whether you want to remove FieldA * strings from the current set:
=Count({<FieldA-={"=index(FieldA,'*')>0"}>}FieldA)
or select the set where FieldA does not contain *
=Count({<FieldA=-{"=index(FieldA,'*')>0"}>}FieldA)
Note the only difference between the two is in the use of -= or =-.
-Rob
Aha, I come up with a compromise solution, that is, use 'if' clause to rename the data '**' to '999999' in the load script, then in the set analysis
count({<FieldA={"*"}-{"999999"}>} id)
To perform forced exclusion of a string you should use '~' before the specific field set analysis.
To include '*' char in string comparison set you should use escape solution (like char(42))
Something like this: Count( {$<~FieldA= {"*$(=chr(42))*"}>} id)
Try different ways to escape '*' char..
Hope that will help you..
To work around the problem of the * being misinterpreted as a wildcard, I would use the set search argument:
{"=index(FieldA,'*')>0"}
Then the exact syntax depends on whether you want to remove FieldA * strings from the current set:
=Count({<FieldA-={"=index(FieldA,'*')>0"}>}FieldA)
or select the set where FieldA does not contain *
=Count({<FieldA=-{"=index(FieldA,'*')>0"}>}FieldA)
Note the only difference between the two is in the use of -= or =-.
-Rob