Page 1 of 1
EmPower Custom Field Calculation
Posted: Fri Jul 22, 2011 8:40 am
by EmPower-Ole
Hello,
is there any possibility to use wildcards in the Custom Field Calculation?
I would like to search the Peak label for the expression eg. "water"
with EQ(Peak Label,"water") it's possible to search for the exact Peak Label "water", but if the peak label is "water water", it wouldn't work. Even EQ(Peak Label,*"water"*) EQ(Peak Label, %"water"%) doesn't work.
So my question:
Is there any formula "like", "isin" or something like that? Or does anyone have another idea?
Thanks for your help
Re: EmPower Custom Field Calculation
Posted: Mon Jul 25, 2011 8:44 am
by aceto_81
I don't know if it could work, but in SQL you should place the wildcard characters between the "".
So EQ(Peak Label, "%water%") might work, but haven't tested it.
Ace
Re: EmPower Custom Field Calculation
Posted: Mon Jul 25, 2011 5:36 pm
by EmPower-Ole
thanks, but that does not work, too
Re: EmPower Custom Field Calculation
Posted: Wed Mar 28, 2012 12:21 pm
by EmPower-Ole
Has anybody found a solution for this problem?
We didn't
Re: EmPower Custom Field Calculation
Posted: Fri Mar 30, 2012 2:30 pm
by cody84
I'm not sure I fully understand what you're asking but what about in the report you can use the sorting filters.
Re: EmPower Custom Field Calculation
Posted: Mon Apr 16, 2012 5:24 pm
by Klaus I.
Has anybody found a solution for this problem?
We didn't
Maybe you should try to mask the string with # (double-cross?)
Re: EmPower Custom Field Calculation
Posted: Tue Apr 17, 2012 6:40 pm
by Klaus I.
Hello,
is there any possibility to use wildcards in the Custom Field Calculation?
I would like to search the Peak label for the expression eg. "water"
with EQ(Peak Label,"water") it's possible to search for the exact Peak Label "water", but if the peak label is "water water", it wouldn't work. Even EQ(Peak Label,*"water"*) EQ(Peak Label, %"water"%) doesn't work.
So my question:
Is there any formula "like", "isin" or something like that? Or does anyone have another idea?
Thanks for your help
But how should empower take a decision to calculate something, when several Labels (Wildcard search) are relevant. Most Probably the label should be well done and unique to perform proper custom field calculations.
Edit:
Finally I have found something for you in an old Millenium Whitepaper (Millennium³² Software’s Sample Set, Component and Inter-Sample Custom Field Capabilities; August 2001). I hope it is useful for you:
8. Inter-Sample Summary – This functionality allows you to generate a result that
is a summary of a certain peak parameter for peaks over multiple results, i.e.
average amount. The syntax is as follows:
Label.Injection.Channel.Function(Value). The % and ? wildcards (see # 13) and
the keyword “SAME” (see # 12) are both useful with this type of field, i.e.
.%..AVE(Amount) or SAME…AVE(Amount). The first formula individually
averages each peak’s Amount field from multiple injections on the same line of
the sample set. The second formula averages the amounts from any result that has
an identical label.
9. Double Quotes String in Inter-sample Label – This functionality allows you to
place a text string in quotes so that it is interpreted literally in the inter-sample
syntax. Otherwise, a label such as SATIN-2 is interpreted to mean SATIN minus
2. Example: “MyLabel*3”.1.“SATIN-2”
...
13. Wildcards – The “%” wildcard specified all labels, injections or channels when
used in the appropriate position of the inter-sample syntax. The “?” wildcard
replaces one character and can also be used in any of the three positions of the
inter-sample syntax.
Re: EmPower Custom Field Calculation
Posted: Tue Apr 17, 2012 10:35 pm
by Hollow
and what do you want to do with it?
first I'm not really into CustomField calculations but, when you assign Peak labes, they are already written in the process method, so why don't you generate some named group out of them and use this label for your CF?
otherwise I guess you have allready tried to use *water*?