Convert the string "5.541.00" to int in C#

Question

What is the correct way to convert a string with the text "5.541,88" to int?

I’m trying to do it this way:

int valor = int.Parse("5.541,88");

But I can’t because it returns the error:

Input string was not in a correct format.

Answer 1

The right shape is using the style of value and the culture it is to be able to identify the pattern.

And of course, check if it worked before using, because it might fail (TryParse()), I will not let the application break down, nor use an exception for a not exceptional situation, it seems to be expected that the data will come to failures. If it is guaranteed that the data will not come with formatting flaws, then you can use the Parse() and without exception.

I’ll use decimal because clearly this is a monetary value, it doesn’t make much sense to try to take the whole value of it, but if you want to do it then just make sure that you want to lose part of the value, this is not part of the conversion itself.

If you really want to convert to whole you can make an explicit conversion (it’s better than a cast because it makes clear the desired semantics and is most likely to catch the best approximation - ToInt32()).

But if you really want to throw away the pennies, then truncate the value (Truncate()).

But if it’s monetary value and you only want to have the whole part then you should keep the type using the Truncate() of the kind decimal.

I made all options in:

using static System.Console;
using static System.Convert;
using static System.Math;
using System.Globalization;

public class Program {
    public static void Main() {
        if (!decimal.TryParse("5.541,88", NumberStyles.Currency, CultureInfo.CreateSpecificCulture("pt-BR"), out var valor)) WriteLine("Formato inválido para conversão");
        WriteLine($"Decimal: {valor}");
        WriteLine($"Inteiro: {ToInt32(valor)}");
        WriteLine($"Inteiro truncado: {Truncate(valor)}");
        WriteLine($"Decimal truncado: {decimal.Truncate(valor)}");
    }
}

Behold working in the ideone. And in the .NET Fiddle. Also put on the Github for future reference.

Answer 2

Conversion is not working because it does not detect the value format, so try:

  string ii = "5541.88";
        float value = float.Parse(ii, System.Globalization.CultureInfo.InvariantCulture.NumberFormat);

Answer 3

One way to solve is to use decimal.parse and then cast to integer value.

Follow an example:

using System;
using System.Globalization;

public class TransformToIntegerRepresentation
{
    public static void Main()
    {
        string valor = "5.541,88";
        NumberStyles style = NumberStyles.AllowDecimalPoint | NumberStyles.AllowThousands;
        CultureInfo provider = new CultureInfo("pt-BR");
    
        try {
            decimal numero = Decimal.Parse(valor, style, provider);
            Console.WriteLine("'{0}' convertido para {1}.", valor, (int) numero);
        } catch (FormatException) {
            Console.WriteLine("Não foi possível representar o valor em um inteiro válido");
        }
    }
}

In this example I am using utility classes to allow the thousand group separator and allow the decimal value separator. I also added a local culture promoter pt-BR. So we can cast a "formatted" decimal number to be represented in pt-BR.

Last time to display the value I force the decimal cast to int.