Using FMA 11, I have a stack of number separated by CR. Some are whole numbers, others have decimal value. I need the stack without any decimals or decimal values. Just 3 4 6 8 not 3 4.3 6.7 8.
Always round down.
Are they imported or entered? Are they separate records or in one field in one record?
Exact information is so useful.
Home > Designing and creating databases > Editing objects on layouts > Formatting and setting up field objects in Layout mode > Specifying formats for fields containing numbershttp://www.filemaker.com/11help/html/edit_layout.10.17.html
This is often referred to as a "list of values" in the filemaker world.
A recursive custom function or a looping script can do this.
Let's say your list of values is in a variable named $$ValueList:
Loop Set variable [$K ; value: $K + 1 ] Exit Loop If [$K > valueCount ( $$ValueList ) ] Set Variable [$IntegerList ; List ( $IntegerList ; Int ( getvalue ( $$ValueList ; $K ) ) ) ]End LoopSet variable [$$ValueList ; value: $IntegerList ]
I have a found set. The stack of values arrives from fn_GetNthRecordSet ( Hardware::Scale_Value ; 1 ; Get(FoundCount))
In that case, a script can loop through the individual records instead of first creating your list of values. If a list of values is what you need, the script can build that list as it loops through the records.
Retrieving data ...