523819_en-US

liliconcom

How to remove leading characters (::) and ending characters (;;) from a column name in a data set

Hey, can you please give me an advice how to remove certain signs like :: at the beginning and ;; at the end of a column names, if available.

Example:

::ColumnName;; --> ColumnName

::ColumnName::XYZ;ABC;; --> ColumnName::XYZ;ABC

123::ColumName --> no change 123::ColumName

Data TableScriptingWindows