Wildcards in empower
Posted: Wed Sep 13, 2017 10:14 am
Hi all,
Does anyone knows how to use (if it is possible ofc...) wildcards in operations on Custom Fields like EQ()?
For exemple, I have this sample set
Smp11
Smp12
Smp21
Smp22
.
.
.
Smpn1
Smpn2
where Smpn1 have label U%1 and Smpn2 have U%2
And I need a CF that calculate the number 0 to Smpn1 and the number 1 to Smpn2
like this EQ(Label,"U%2"). But empower only understands the wildcard % in intersamples calculation, and the wildcard * in label reference and report filters. When is a string value like EQ(Label,"") i dont know what wildcard its possible to use.
Any thoughts?
Thanks
Does anyone knows how to use (if it is possible ofc...) wildcards in operations on Custom Fields like EQ()?
For exemple, I have this sample set
Smp11
Smp12
Smp21
Smp22
.
.
.
Smpn1
Smpn2
where Smpn1 have label U%1 and Smpn2 have U%2
And I need a CF that calculate the number 0 to Smpn1 and the number 1 to Smpn2
like this EQ(Label,"U%2"). But empower only understands the wildcard % in intersamples calculation, and the wildcard * in label reference and report filters. When is a string value like EQ(Label,"") i dont know what wildcard its possible to use.
Any thoughts?
Thanks