I do a lot of file parsing, which involves parsing data types like decimal. To help make the code more readable, I've been using the following method:
public static decimal? ToDecimal(this string data)
{
decimal result;
if (decimal.TryParse(data, NumberStyles.Integer | NumberStyles.AllowDecimalPoint, CultureInfo.InvariantCulture, out result))
return result;
return null;
}
This works fine for decimals which are represented with a full-stop/period as the decimal separator. However, I'd like this function to work with other standard decimal separators, particularly the comma. (I read that there is also an Arabic decimal separator: http://en.wikipedia.org/wiki/Decimal_mark#Other_numeral_systems, but that presumably relies on being able to parse the eastern arabic numerals too).
The Culture.CurrentCulture wouldn't be appropriate because the data is not necessarily created on the machine that is doing the processing. So I've now got this:
private static CultureInfo CreateCultureWithNumericDecimalSeparator(string separator)
{
var cultureInfo = (CultureInfo)CultureInfo.InvariantCulture.Clone();
cultureInfo.NumberFormat.NumberDecimalSeparator = separator;
return cultureInfo;
}
private static CultureInfo[] cultureInfos = new CultureInfo[]
{
CultureInfo.InvariantCulture,
CreateCultureWithNumericDecimalSeparator(",") // Normal comma
};
public static decimal? ToDecimal(this string data)
{
foreach (CultureInfo cultureInfo in cultureInfos)
{
decimal result;
if (decimal.TryParse(data, NumberStyles.Integer | NumberStyles.AllowDecimalPoint, cultureInfo, out result))
return result;
}
return null;
}
This works, but parsing twice, especially given that TryParse is checking all sorts of settings (thousand separators, hex specifiers, currency symbols, exponents, etc) seems a little heavy. It's probably not a performance issue, but I'm curious to know if there's a more efficient method to do this, or possibly even an existing method within the framework? And maybe even a method that could cope with other numeral systems in modern use? Thanks.
