Pam OBrien Posted April 14, 2020 Share Posted April 14, 2020 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, Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted April 15, 2020 Share Posted April 15, 2020 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)) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now