Page 1 of 1
ordinals
Posted: Sat Sep 19, 2009 8:45 pm
by Namp
hi there again,____what function in RR converts numerics to ordinals?____thanks,____Namp
=> RE: ordinals
Posted: Tue Sep 22, 2009 3:44 pm
by kfleming
What output format do you need?__Kathleen__R&R Support
==> RE: ordinals
Posted: Sat Sep 26, 2009 11:57 am
by Namp
____like 1 as 1st, 2 as 2nd, 3 as 3rd and so on.____
===> RE: ordinals
Posted: Mon Sep 28, 2009 10:16 am
by kfleming
Create a user defined function called Ordinal with the declaration:__Ordinal(n_value)____and expression:__ltrim(str(value)+case(right(str(value),2),"11","th","12","th","13","th",case(right(str(value),1),"1","st","2","nd","3","rd","th")))____You can then use the function named Ordinal to convert a numeric value to an ordinal string.____Kathleen__R&R Support