You can transform the sample file as follows:
- Extract record type from each row.
- Derive tables for each record type and filter rows to keep only one record type per derived table.
- In each derived table, use the “Split fixed width text” action to split text into columns.
- Merge the result back into one table using the “Append table” action in the “Append columns” mode.
See the example project below:
load varying column width text.morph (5.7 KB)