I have a column with integers and i wish to have calculated column to sort the integer from BIG to SMALL...and always have 4 digits...anyone can help?

[Chee Kheong Wan]

Example

6329 => 9632

1234 => 4321

985  => 9850

2002 => 2200

1    => 1000 

[Gaia Paolini]

I cannot see a way of doing it with a simple Spotfire expression. I would suggest to create the new column using a TERR expression function.

To create it, go to menu > Data > Data Function Properties > Expression Functions tab.

Then choose New.. and add a Column Function with return type Integer and category Statistical Function, using the following script:

sort4digits = function(v) { vi=strsplit(as.character(v),'')[[1]] vi=sort(vi,decreasing=TRUE) vi=c(vi,rep(0,4-length(vi))) vi=as.integer(paste(vi,collapse='')) return (vi)} output = sapply(input1,sort4digits)

The sort4digits function takes each integer, e.g. 6329, splits it into a vector, sorts the vector highest first, pads it with zeroes if shorter than 4, then re-collapses the four digits into an integer. Then the output column is created by applying this function to all rows.

Call this expression function e.g. TERR_sortMe.

Then create your new column as the following expression:

TERR_sortMe([value])

where [value] will be your original column.