FormattedBytes ( Bytes ; Rounding ; bitsOrBytes ; DecimalOrBinaryIEC )

Convert bit and byte to a formatted output

Average rating: 4.2 (38 votes) Log in to vote

Stefano Monti
Plan Art
http://www.planart.it

Sample input:

FormattedBytes ( 9819 ; 1 ; 0 ; 0 )
FormattedBytes ( Length ( ContainerField ) ; 2 ; 0 ; 0 )
FormattedBytes ( FieldContaining_bites_value ; 0 ; 1 ; 1 )

Sample output:

9,6 KB
9,59 KB
24 Kb

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

Let (
[
// if you desire to convert and show bites measure unit must set to 1, instead for Bytes must set to 0
TheB = if ( bitsOrBytes ; "b" ; "B" ) ;
TheBExtended = if ( bitsOrBytes ; " bite" ; " Byte" ) & if ( Bytes > 1 ; "s" ; "" ) ;
// if want convert using the 1000 decimal unit set to 1 else set to 0 for using the 1024 IEC standard binary conversion unit
Kilo = if ( DecimalOrBinaryIEC ; 1000 ; 1024 ) ;
// for Bytes assume a height measure of an image or of a file, example: set here Lenght ( ContainerFieldOfAnImage )
B = Bytes ; 
KB = B / Kilo ;
MB = KB / Kilo ;
GB = MB / Kilo ;
TB = GB / Kilo ;
PB = TB / Kilo ] ;
Case ( 
Round ( PB ; 0 ) ; Round ( PB ; Rounding ) & " P" & TheB ;
Round ( TB ; 0 ) ; Round ( TB ; Rounding ) & " T" & TheB ;
Round ( GB ; 0 ) ; Round ( GB ; Rounding ) & " G" & TheB ;
Round ( MB ; 0 ) ; Round ( MB ; Rounding ) & " M" & TheB ;
Round ( KB ; 0 ) ; Round ( KB ; Rounding ) & " K" & TheB ;
B & TheBExtended )
)

Anytime you need to convert from Bytes to KBytes ( also MB, GB, TB, PB ), or from bits to Kbits ( Mb, Gb, Tb, Pb ), enjoy this function!

Comments

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

FormattedBytes ( Bytes ; Rounding ; bitsOrBytes ; DecimalOrBinaryIEC )

Comments

Support this website.

Support this website.