Spotfire: Split a column from the Details on selected column panel

Prior to this task: 

✔ Data must be loaded.

1️⃣ Active page ➡ select  [Data in analysis]
2️⃣ Data in analysis flyout ➡ select column to split
3️⃣ Expanded data in analysis flyout ➡ select [Details on selected column]
4️⃣ Details on selected column panel ➡ Actions ➡ select  [Split column...]
5️⃣ Split Column ➡ enter Split using this separator Number of new columns Number of characters to remove from original string before splitting  [Split from beginning/end of string]
6️⃣ Split Column ➡ select [OK]

Supporting Knowledge

Optionally, the user may want to remove unwanted characters from the beginning or end of the original string before performing the split. For example, if you have string values within a parenthesis or within quotation marks, you can trim away these characters by specifying several characters to remove from the beginning or end of the string.

Optionally, if the user is more interested in the values at the end of the string, the Split from end of string option can be used to start counting the substrings to extract from the end instead of from the beginning.