Jump to content

Recommended Posts

Posted

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,

Posted

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))

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...