Spreadsheet loading

[Pam OBrien]

I am new to Spotfire - so bear with me. I have a spreadsheet I want to load.

I need one of the columns split from this string100/10-24-071-05W4/00 to these: 100 10 24 071 05W4/00

Can this be done in spotfire or should I manipulate the spread sheet prior to loading

Thanks,

[Shashank Gurnalkar]

If the pattern of occurrences of all the string values in that column issame, you can use the following expression in a calculated column.

Concatenate(Substring([ColumnName],1,3)," ",Substring([ColumnName],5,2)," ",Substring([ColumnName],8,2)," ",Substring([ColumnName],11,3)," ",Substring([ColumnName],15,7))