Regular Expression to parse a currency with any symbol

**Jesse Houwing** · Jul 5 '06, 11:05 PM

Re: Regular Expression to parse a currency with any symbol

Hey Mike,

Your regex matches a lot more than you're actually trying to find. The
following should be more in the general direction you're trying to find:

@"\(\d{1,3}(?:, \d{3})*(?:\.\d+ )?\)|-?\d{1,3}(?:,\d{ 3})*(?:\.\d+)?" ;

Do keep in mind that \d*,*\d*\.?\d* will match
234234,,,,,,,,, 918723912793791 237918273921739 12379172398.821 63816238716238
as well, which is probably not what you're looking for. If you want to
allow any format that is using either the thousand separator or not you
could also use this:

@"\(\d{1,3}(?:, ?\d{3})*(?:\.\d +)?\)|-?\d{1,3}(?:,?\d {3})*(?:\.\d+)? ";

Also notice that I basically check for the () notation and then for the
- notation. Your regex would also have found:

(-99 or -99)

Jesse Houwing

Mike9900 wrote:

Hello,
>
I need a regular expression to match a currency with its symbol, for example
Pound66.99 must return 66.99 or Pound(66.99) or Pound-66.99 or -66.99Pound
return -66.99 or any other combination return the decimal number.
>
I have created a regular expression, but it seems that it does not work if
the number is Pound66.99 but it works if the sign is after the number:
>
public static Decimal ConvertToDecima l(String str)
{
String pattern = @"^\(?-?[\d]*[,]*[\d]*\.?[\d]*\)?";
System.Text.Reg ularExpressions .Match match
=System.Text.Re gularExpression s.Regex.Match(s tr, pattern);
if (match.Success)
{
decimal result;
//try to parse to decimal normally
if (decimal.TryPar se(match.Groups[0].ToString(),
System.Globaliz ation.NumberSty les.Any, null, out result))
return result;
}
return 0;
}--
Mike

**John B** · Jul 6 '06, 05:55 AM

Re: Regular Expression to parse a currency with any symbol

Mike9900 wrote:

Hello,
>
I need a regular expression to match a currency with its symbol, for example
Pound66.99 must return 66.99 or Pound(66.99) or Pound-66.99 or -66.99Pound
return -66.99 or any other combination return the decimal number.
>
I have created a regular expression, but it seems that it does not work if
the number is Pound66.99 but it works if the sign is after the number:
>
public static Decimal ConvertToDecima l(String str)
{
String pattern = @"^\(?-?[\d]*[,]*[\d]*\.?[\d]*\)?";
System.Text.Reg ularExpressions .Match match
=System.Text.Re gularExpression s.Regex.Match(s tr, pattern);
if (match.Success)
{
decimal result;
//try to parse to decimal normally
if (decimal.TryPar se(match.Groups[0].ToString(),
System.Globaliz ation.NumberSty les.Any, null, out result))
return result;
}
return 0;
}--
Mike

Or a totally different solution:

if(currencyStri ng.IndexOf("pou ndSign") != -1)
{
currencyString = currencyString. Replace("poundS ign", "");
}
....tryparse as before

**Mike9900** · Jul 6 '06, 07:55 AM

Re: Regular Expression to parse a currency with any symbol

This does not work, because I do not know the currency symbol. It could be
franc ro any other, such as FR-888.22.
--
Mike

"John B" wrote:

Mike9900 wrote:

Hello,

I need a regular expression to match a currency with its symbol, for example
Pound66.99 must return 66.99 or Pound(66.99) or Pound-66.99 or -66.99Pound
return -66.99 or any other combination return the decimal number.

I have created a regular expression, but it seems that it does not work if
the number is Pound66.99 but it works if the sign is after the number:

public static Decimal ConvertToDecima l(String str)
{
String pattern = @"^\(?-?[\d]*[,]*[\d]*\.?[\d]*\)?";
System.Text.Reg ularExpressions .Match match
=System.Text.Re gularExpression s.Regex.Match(s tr, pattern);
if (match.Success)
{
decimal result;
//try to parse to decimal normally
if (decimal.TryPar se(match.Groups[0].ToString(),
System.Globaliz ation.NumberSty les.Any, null, out result))
return result;
}
return 0;
}--
Mike

>
Or a totally different solution:
>
if(currencyStri ng.IndexOf("pou ndSign") != -1)
{
currencyString = currencyString. Replace("poundS ign", "");
}
....tryparse as before
>

**Mike9900** · Jul 6 '06, 08:05 AM

Re: Regular Expression to parse a currency with any symbol

Thanks for the help.

This does not work for some numbers, for example if the number is E.999 it
return 999, if the number is e999,323,22.98 it returns 999323.

Please note that I use Decimal.parse with
System.Globaliz ation.NumberSty les.Any afterward, so the most important thing
is that it strips symbol and gives the correct number.

Or should I use the normal loop and strip symbols?
--
Mike

"Jesse Houwing" wrote:

Hey Mike,
>
Your regex matches a lot more than you're actually trying to find. The
following should be more in the general direction you're trying to find:
>
@"\(\d{1,3}(?:, \d{3})*(?:\.\d+ )?\)|-?\d{1,3}(?:,\d{ 3})*(?:\.\d+)?" ;
>
Do keep in mind that \d*,*\d*\.?\d* will match
234234,,,,,,,,, 918723912793791 237918273921739 12379172398.821 63816238716238
as well, which is probably not what you're looking for. If you want to
allow any format that is using either the thousand separator or not you
could also use this:
>
@"\(\d{1,3}(?:, ?\d{3})*(?:\.\d +)?\)|-?\d{1,3}(?:,?\d {3})*(?:\.\d+)? ";
>
Also notice that I basically check for the () notation and then for the
- notation. Your regex would also have found:
>
(-99 or -99)
>
Jesse Houwing
>
Mike9900 wrote:

Hello,

I need a regular expression to match a currency with its symbol, for example
Pound66.99 must return 66.99 or Pound(66.99) or Pound-66.99 or -66.99Pound
return -66.99 or any other combination return the decimal number.

I have created a regular expression, but it seems that it does not work if
the number is Pound66.99 but it works if the sign is after the number:

public static Decimal ConvertToDecima l(String str)
{
String pattern = @"^\(?-?[\d]*[,]*[\d]*\.?[\d]*\)?";
System.Text.Reg ularExpressions .Match match
=System.Text.Re gularExpression s.Regex.Match(s tr, pattern);
if (match.Success)
{
decimal result;
//try to parse to decimal normally
if (decimal.TryPar se(match.Groups[0].ToString(),
System.Globaliz ation.NumberSty les.Any, null, out result))
return result;
}
return 0;
}--
Mike

>

**Jesse Houwing** · Jul 6 '06, 08:45 AM

Re: Regular Expression to parse a currency with any symbol

Mike9900 wrote:

Thanks for the help.
>
This does not work for some numbers, for example if the number is E.999 it
return 999, if the number is e999,323,22.98 it returns 999323.

Yeah I made the expression quite strict the option with no digits before
the '.' wasn't in your sample data and 999,333,22 is syntactically
incorrect as the last part should contain 3 digits. These changes would
be quite simple to implement however:

\((?:\d{1,3}(?: ,?\d+)*(?:\.\d+ )?|\.\d+)\)|-?(?:\d{1,3}(?:, ?\d+)*(?:\.\d+) ?|\.\d+)

would probably catch these aswell.

Jesse

>
Please note that I use Decimal.parse with
System.Globaliz ation.NumberSty les.Any afterward, so the most important thing
is that it strips symbol and gives the correct number.
>
Or should I use the normal loop and strip symbols?

**Larry Lard** · Jul 6 '06, 09:45 AM

Re: Regular Expression to parse a currency with any symbol

Mike9900 wrote:

"John B" wrote:
>

Mike9900 wrote:

Hello,
>
I need a regular expression to match a currency with its symbol, for example
Pound66.99 must return 66.99 or Pound(66.99) or Pound-66.99 or -66.99Pound
return -66.99 or any other combination return the decimal number.
>
I have created a regular expression, but it seems that it does not work if
the number is Pound66.99 but it works if the sign is after the number:
>
public static Decimal ConvertToDecima l(String str)
{
String pattern = @"^\(?-?[\d]*[,]*[\d]*\.?[\d]*\)?";
System.Text.Reg ularExpressions .Match match
=System.Text.Re gularExpression s.Regex.Match(s tr, pattern);
if (match.Success)
{
decimal result;
//try to parse to decimal normally
if (decimal.TryPar se(match.Groups[0].ToString(),
System.Globaliz ation.NumberSty les.Any, null, out result))
return result;
}
return 0;
}--
Mike

Or a totally different solution:

if(currencyStri ng.IndexOf("pou ndSign") != -1)
{
currencyString = currencyString. Replace("poundS ign", "");
}
....tryparse as before

This does not work, because I do not know the currency symbol. It could be
franc ro any other, such as FR-888.22.

So the best thing to do is assume the currency symbol could in fact be
anything at all, since storing a list of all known currencies would be
silly. So do this:

- remove all characters that aren't digits, sign characters, decimal
points.
- look for a sign character, and note it and remove it if found
- parse what remains as a number
- apply the sign

Regex is inappropriate when you know so little about the format of your
input.

--
Larry Lard
Replies to group please
When starting a new topic, please mention which version of VB/C# you
are using

**Mike9900** · Jul 6 '06, 02:35 PM

Re: Regular Expression to parse a currency with any symbol

Thank you for the help. It is now working!
--
Mike

"Jesse Houwing" wrote:

Mike9900 wrote:

Thanks for the help.

This does not work for some numbers, for example if the number is E.999 it
return 999, if the number is e999,323,22.98 it returns 999323.

>
Yeah I made the expression quite strict the option with no digits before
the '.' wasn't in your sample data and 999,333,22 is syntactically
incorrect as the last part should contain 3 digits. These changes would
be quite simple to implement however:
>
>
\((?:\d{1,3}(?: ,?\d+)*(?:\.\d+ )?|\.\d+)\)|-?(?:\d{1,3}(?:, ?\d+)*(?:\.\d+) ?|\.\d+)
>
>
would probably catch these aswell.
>
Jesse
>

Please note that I use Decimal.parse with
System.Globaliz ation.NumberSty les.Any afterward, so the most important thing
is that it strips symbol and gives the correct number.

Or should I use the normal loop and strip symbols?

>

**Mike9900** · Jul 6 '06, 02:35 PM

Re: Regular Expression to parse a currency with any symbol

This is another way, thanks. But it is possible to use regular expression.
Please see the message.
--
Mike

"Larry Lard" wrote:

>
Mike9900 wrote:

"John B" wrote:

Mike9900 wrote:
Hello,

I need a regular expression to match a currency with its symbol, for example
Pound66.99 must return 66.99 or Pound(66.99) or Pound-66.99 or -66.99Pound
return -66.99 or any other combination return the decimal number.

I have created a regular expression, but it seems that it does not work if
the number is Pound66.99 but it works if the sign is after the number:

public static Decimal ConvertToDecima l(String str)
{
String pattern = @"^\(?-?[\d]*[,]*[\d]*\.?[\d]*\)?";
System.Text.Reg ularExpressions .Match match
=System.Text.Re gularExpression s.Regex.Match(s tr, pattern);
if (match.Success)
{
decimal result;
//try to parse to decimal normally
if (decimal.TryPar se(match.Groups[0].ToString(),
System.Globaliz ation.NumberSty les.Any, null, out result))
return result;
}
return 0;
}--
Mike
>
Or a totally different solution:
>
if(currencyStri ng.IndexOf("pou ndSign") != -1)
{
currencyString = currencyString. Replace("poundS ign", "");
}
....tryparse as before

>

This does not work, because I do not know the currency symbol. It could be
franc ro any other, such as FR-888.22.

>
So the best thing to do is assume the currency symbol could in fact be
anything at all, since storing a list of all known currencies would be
silly. So do this:
>
- remove all characters that aren't digits, sign characters, decimal
points.
- look for a sign character, and note it and remove it if found
- parse what remains as a number
- apply the sign
>
Regex is inappropriate when you know so little about the format of your
input.
>
--
Larry Lard
Replies to group please
When starting a new topic, please mention which version of VB/C# you
are using
>
>

**Jesse Houwing** · Jul 6 '06, 02:35 PM

Re: Regular Expression to parse a currency with any symbol

Mike9900 wrote:

Thank you for the help. It is now working!

You're Welcome :)

Jesse

**Jesse Houwing** · Jul 7 '06, 05:15 AM

Re: Regular Expression to parse a currency with any symbol

Mike9900 wrote:

This is another way, thanks. But it is possible to use regular expression.
Please see the message.

Larry was completely correct that without specs you won't get it done
using regular expressions, but after we had the specs clear, it was no
issue :)

Jesse

Regular Expression to parse a currency with any symbol

Regular Expression to parse a currency with any symbol

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment