Custom fields 1-10 may be filled if the data has been acquired with OpenLab CDS ChemStation Edition. |
The content of custom fields 1-10 is composed of a label, a separator, and a value.
If you only refer to the field name, the plain content of the custom field is shown. In order to calculate with the content, you must first transform the content to a number using the Val function. RTE automatically creates this expression for you when you add one of the fields.
The following examples show you the results for a sample custom field containing the label TabletWeight and the Value 1020.
Expression |
Result |
---|---|
=Sample_CustomField01 |
TabletWeight|1020 |
=Trim(Choose(1,Split( Sample_CustomField01 ,"|"))) | TabletWeight |
=Trim(Choose(2,Split( Sample_CustomField01 ,"|"))) | 1020 (returned as a string) |
=2 * Val(Trim(Choose(2,Split( Sample_CustomField01 ,"|")))) |
2040 (calculated number) |
If there are more than ten custom fields defined, they are stored in the complex custom fields Sample_CustomFields or Compound_CustomFields. Use the same expression as for complex custom fields to access the values (see Calculate with a complex custom field). You need to know the label of the required custom field.