String Operation before and after "-"

Fine
Then the expression be like this
str_output = IF(row(“yourcolumnname”).ToString.ToUpper.Startswith(“MAPPING”),Split(row(“yourcolumnname”).ToString,”-“)(1).ToString.Trim,Split(row(“yourcolumnname”).ToString,”-“)(0).ToString)

Cheers @Ankita_Biswas_SDC_Ko

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.