Regexfile

Help Activities
1

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

2

Hi @hanviprebday

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

image
image1427×527 15.5 KB

Hope it helps!!

3

grafik

4

@hanviprebday

you can try this way also

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

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:

Cheers!!

6

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