RoundNumbersInList ( Data,Precision )

Loop and Round list of comma separated numbers in a Filemaker list

Be the first to rate this function Log in to vote

Binu Alexander - Show more from this author
SevenX Ltd.
https://www.linkedin.com/in/drbinualexander/

Sample input:

RoundNumbersInList ( "9.25,3.42.3,4.22,63.23" ; 1 )

Sample output:

9.3,3.4,4.2,63.2

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Substitute ( While ( 

[ 
  theList = Substitute ( Data ; "," ; "¶" ); 

  listLength = ValueCount ( theList ); 

  theResult = ""; 

  counter = 0 

] ;

counter < listLength ; 

[ 
  counter = counter + 1 ;

  // Add a carriage return before each item, except for the first item

  theResult = theResult & If ( counter > 1 ; "¶" ; "" ) & Round( GetValue ( 
theList ; counter );Precision )
] ; 

theResult

) ; "¶" ; "," )



/*
  Function Name: RoundAndListValues
  Author: Binu Alexander -  SevenX Ltd. 
  Date: 12/11/2023
  Description: This function takes a comma-separated list of numbers and a level of precision as input, rounds each number to the precision specified 
  and returns a carriage return-separated list of the rounded numbers.
*/

This function takes a comma-separated list of numbers as input, rounds each number to the precision specified and ultimately returns a carriage return-separated list of the rounded numbers.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

RoundNumbersInList ( Data,Precision )

Comments

Support this website.

Support this website.