Hi friends,

I need to extract amount from a file.

Amount :#654,768,7654.00#
This amount is not constant it keeps varying.
I should use regex.

Plz help ne

Hi @hanviprebday

Input="Amount :#654,768,7654.00#"
Output= System.Text.RegularExpressions.Regex.Match(Input,"[\d,.]+").Value

Hope it helps!!



you can try this way also

new String(inputstr.Where(Function(a)  char.IsNumber(a)).ToArray)

Hi @hanviprebday

Try this Regex

Var= Amount :#654,768,7654.00#"

System.Text.RegularExpressions.Regex.Match(Var, “(?<=Amount\s*:\s*#)([\d,]+.\d{2})(?=#)”).Value

Hope this helps you :slight_smile:


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.