Wildcards in empower

Discussions about chromatography data systems, LIMS, controllers, computer issues and related topics.

7 posts Page 1 of 1
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
Hi

EQ = Boolean field (Bool)
So will give logical values

I have only used % and EQ function for a complex Max impurity in duplicate samples ie ENUM(EQ(Sample1%.%.%MAX(% Area)... (I can send full CF is that helps)
I use that wildcard too but inside the "" in that exemple I dont know what wildcard is used.

thanks for your reply :)
Hi

Understood ,,Try :

EQ(Label,U02%.%..) or EQ(EQ(Label,U02%.%.%)

Sorry , I dotn have empower in front of me
dont work, the syntax EQ(Label,"") requires the "" and text inside it.

thanks
Anyone knows? or have more ideia? plz help

Thanks
Yeah I got this wrong

You may have to look into adding an extra custom field for each sample but that does sound daft (one for each sample) or try ENUM type ?
7 posts Page 1 of 1

Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 1117 on Mon Jan 31, 2022 2:50 pm

Users browsing this forum: No registered users and 1 guest

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food & Beverage, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.

Liquid Chromatography

Gas Chromatography

Mass Spectrometry