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


日期: 11/04/2020
类别: SCIEX OS , MultiQuant Software

0 投票数
   打印    评价文章:

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