OK, this might require a bit of lateral thinking. It looks like each value will have a single space separating it from another value. It also looks like the first 6 values will always be provided and are required in their own columns. The rest are required in a single column. Do you know you can guarantee those rules for the whole dataset? If so, some simple Java may help you work with this. You *could* use a simple loop to iterate over the first 6 columns and leave the remaining data in the 7th column.
To do this you could use a tJavaRow component and use some Java like below....
String data = input_row.my_column;
String[] values = new String;
for(int i = 0; i<6; i++){
values = data.substring(0, data.indexOf(" "));
data = data.substring(data.indexOf(" ")+1);
}
output_row.col1 = values;
output_row.col2 = values;
output_row.col3 = values;
output_row.col4 = values;
output_row.col5 = values;
output_row.col6 = values;
output_row.col7 = data;
.....to provide 7 columns with the data split as you wish. Obviously these are all Strings in this example so you may want to cast to other types and the long String of values you may want to convert to a List (this can be done with some extra processing of the "data" variable before assigning it to col7....check out ArrayLists in Java).
