Regexp pdf extraction to excel

Help Automation Hub
,
1

Getting value from pdf1
Subtotal

Tax Amount

Total

15,070.07

753.50

$15,823.57

Getting value form PDF2

Subtotal 3,958.07

Tax Amount 197.90

Total $4,155.97

getting value from pdf1 and pdf2 are different format,
so please help on how get the values using reg exp or string manipulaltion

Subtotal
Tax Amount
Total

2

@Madhusudhana_gupta_kullur

For the first format use split activity

Str.Split({Environment.NewLine},Stringsplitoptions.None) now in array index 3-5 are the required totals

For the second format use regex

system.Text.Regularexpressions.Regex.Match(str,"(?<=Tax Amount).*").Value.Trim

Hear change each to get each value

Cheers

3

Thanks so much

1 Like