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

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.



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))