iOS Question Specify thousands separator

[Lucas Eduardo]

Hello,
I did not find anything like this in B4I forum.

Specify thousands separator?

Hi All, I have been searching for a way for the user to specify/select their preferred separator in decimal numbers. IE Thousands separator can be comma-dot-space or none. This has been asked in the distant past but I see no real solution. Regards Roger

www.b4x.com

Is there a way to do the same thing in B4I?

Thanks

 

[JordiCP]

Try this

Sub NumberFormat3(num As Double, groupSeparator As String, decimalSeparator As String, maxFractions As Int) As String
    Dim no As NativeObject = Me
    Dim objRes As Object = no.RunMethod("NumberFormat3::::",Array(num,groupSeparator,decimalSeparator,maxFractions))
    Dim res As String = objRes ' Will cast it directly to String
    Return res
End Sub

#if OBJC
// From: https://stackoverflow.com/questions/10103270/how-to-use-thousand-separator-in-nsstring

-(NSString*)NumberFormat3: (double)num : (NSString*)groupSeparator :(NSString*)decimalSeparator :(int)numFractionDigits {
    NSNumberFormatter *numberFormatter = [[NSNumberFormatter alloc] init];
    //[numberFormatter setGroupingSeparator:@","];
    [numberFormatter setGroupingSeparator:groupSeparator];
    [numberFormatter setGroupingSize:3];
    [numberFormatter setUsesGroupingSeparator:YES];
    [numberFormatter setDecimalSeparator:decimalSeparator];
    [numberFormatter setNumberStyle:NSNumberFormatterDecimalStyle];
    [numberFormatter setMaximumFractionDigits:numFractionDigits];//2
    NSString *theString = [numberFormatter stringFromNumber:[NSNumber numberWithDouble:num]];
    return theString;
}
#End If

Usage example:

    Dim myNum as Double = 123456.789012
    Log($"Formating ${myNum} result is: '${NumberFormat3(myNum,",",".",1)}'"$)
    
    ' Log output should be --> Formating 123456.789012 result is: '123,456.8'

(In the source SO code there is also a way to format according to locale settings, the code above is to format with chosen group and decimal separators)

 

[Lucas Eduardo]

It works, but when i put numFractionDigits = 2 it's not appling two digits after comma if there is a zero in the final number.
Example:

Log($"Formating ${1222.50} result is: '${NumberFormat3(1222.50,".",",",2)}'"$)

It's returning 1.222,5 without zero, if number has like 1.222,55 works good, with zero the code cuts the zero.

What could be?

Thank you.

 

[josejad]

Maybe this could be useful? Not sure if it works on iOS

[solved] Setting a decimal separator

Hi all, I'm aware of a few ways to set a decimal separator so to output a double according to locale settings or whatever is needed, but I'd like to know if it can be easily done by using JavaObject alone. To be clear, I saw the thread about using AHlocale+JO+Reflection I know how to do it...

www.b4x.com

 

[JordiCP]

(Untested, but should work)

-(NSString*)NumberFormat3: (double)num : (NSString*)groupSeparator :(NSString*)decimalSeparator :(int)numFractionDigits 
{
   NSNumberFormatter *numberFormatter = [[NSNumberFormatter alloc] init];
   [numberFormatter setGroupingSeparator:groupSeparator];
   [numberFormatter setGroupingSize:3];
   [numberFormatter setUsesGroupingSeparator:YES];
   [numberFormatter setDecimalSeparator:decimalSeparator];
   [numberFormatter setNumberStyle:NSNumberFormatterDecimalStyle];
   [numberFormatter setMinimumFractionDigits:numFractionDigits];      // <--------- ADD THIS LINE
   [numberFormatter setMaximumFractionDigits:numFractionDigits]; 
   NSString *theString = [numberFormatter stringFromNumber:[NSNumber numberWithDouble:num]];
   return theString;
}

 

[Lucas Eduardo]

Maybe this could be useful? Not sure if it works on iOS

I was trying to convert to nativeObject. Thank you for your reply.

(Untested, but should work)

Works good, thank you.

 

[Erel]

Cross platform code:

Dim formatter As B4XFormatter 'B4XFormatter internal library
formatter.Initialize
Dim df As B4XFormatData = formatter.GetDefaultFormat
df.DecimalPoint = ","
df.GroupingCharacter = "."
df.MaximumFractions = 2
df.MinimumFractions = 2
Log(formatter.Format(1222.5))

Make formatter a global variable and use it whenever you need.