Hi all,

How can I get the number like this:

My number field 10,[color:red]567.89

Now I need to get the number [color:red]5, can this be done? I was using Left function but can't do it.

Any Idea? Thank for reply!

You need to supply more information with this. Why are you doing this? Are you looking for the number '5' or are you looking for the third digit from the decimal point (hundred)

Hi,

One tidbit if you need to use a text function, convert the number to text using GetAsText(number) like so.

Filter(GetAsText(12345.60);"5")

would return = 5

Tim

Here's my stab at it:

Let([tt=Int(entry);ss=Length(tt)];

Replace ( tt ; ss-2; 1 ; "," & TextColor(Middle ( tt ; ss-2 ; 1 );16711680)) & "." & Middle(entry-tt & "00";2;2))

Provided you wish to colour the digit red in a text field with the number string ...otherwise can you tear appart the components to get what you're after.

--sd

Hi mr_vodka,

You are right! I'm looking for the third digit from the decimal point and not only third digit I need to looking up all the digit one by one. Like:

Amount field - 10,567.89

Field 1 - 9

Field 2 - 8

Field 3 - 7

Field 4 - 6

Field 5 - 5

Field 6 - 0

Field 7 - 1

Any Idea? Thank for reply!

If you divide 10,567.89 by 100, you'll get 105 (using the Div() function).

Divide that by 10, and the remainder is 5 (use the Mod() function).

Field 1 - 9

Field 2 - 8

Field 3 - 7

Field 4 - 6

Field 5 - 5

Field 6 - 0

Field 7 - 1

Since you can cut up a repeating field could this be written into a single repeating calc'field:

Mod ( Div ( Round(Extend ( entry );2) ; 10^(Get (CalculationRepetitionNumber )-3) ) ; 10 )

--sd

I will attach the sample file for more uderstanding, Thank you all for reply.

Get_Separate_Amount.zip

See the file I have posted here.

Pretty cool, thanks comment.