Spotfire Ideas Portal
Sometimes source data tables are in the format of fixed width, no delimiter being used. Below is an example. Each field has a fixed width of 3 characters, but no delimiter.
a def gh |
abc def g |
ab de ghi |
Importing data like this into Spotfire, there will be only one column. Then extra data transformations are needed to split it into a number of columns.
It would be great if Spotfire can handle this type of import out of the box. More like in Excel, the 'Text to Columns' feature.
Here is the end result from Excel.
The example auto trimmed the spaces. Source table would be like below, * being spaces.
a***def*gh*
abc*def*g**
ab**de**ghi