How to Remove the Extra Characters from an Analyte Name in a Report


Date: 11/05/2020
Categories: SCIEX OS , MultiQuant Software

0 Votes
   Print    Rate Article:

For research use only. Not for use in diagnostic procedures.


Answer

To report the analyte name in a report without additional characters showing, use the TRIM and LEN functions in the expression written in the Math Field Type tag in the report template.

User-added image

For example, if the analyte peak name appears as Naloxone 1 in the report template, but you would like to report the analyte as just Naloxone, then use the expression below to remove the space and the 1 after Naloxone:

TRIM(LEFT(($Analyte_Peak_Name),LEN($Analyte_Peak_Name)-2))
Â