AnsweredAssumed Answered

extract the 1st 2nd 3rd etc value of a number

Question asked by tc_fmdev on Sep 29, 2014
Latest reply on Sep 29, 2014 by tc_fmdev

Title

extract the 1st 2nd 3rd etc value of a number

Post

I have a number that has 4 places to the right of decimal example:  98765.4321

I am trying to extract each position from the right into a field

So i have a field ready for each position

1 =1      2=2      3=3     4=4      5=.      6=7     7=8   etc etc

I tried right but it is picking up x-number of characters...but I only need the 1 character/value from each.

I thought this would work but it is doing the same as Right.

RightValues ( Right ( MyField ; 1 ) ; 1 )

T

 

 

 

 

 

 

Outcomes