Pdf read and make excel sheet

Help Robot
,
1

Hey i want to read pdf and want to make excel sheet by reading pdf get data value and make data table how i can do this and pls tell me
71025674NEFT OUT regex exp of 71025674 this no

2

Hi @Kuldeep_Pandey

How about this Regex expression?

System.Text.RegularExpressions.Regex.Match(YourString,"\d*").Tostring

image

Regards
Gokul

3

image
image1121×480 32.8 KB

image
image700×535 15.7 KB

Why its not getting value in the excel sheet its giving me the regex value which i have applied in build data table activity

4

HI @Kuldeep_Pandey

One topic for one issue. So you can create the new topic for this issue.

Have you check this expression?

Regards
Gokul

5

hey i have many thing in my pdf its not finding excatly this value pls give me exp to find excatllay this value

6

Hi @Kuldeep_Pandey

Can you share the input text with more accurate. So i will create the expression

Regards
Gokul

7

This number length will be also constant? @Kuldeep_Pandey

8

yes constant

9

11.AUG 2022 EFT OUTGOING
71025688NEFT OUT UTR
CITIN22319610624 TRF TO
MOTHERSON TECHNOLOGY
SERVICES LTD 7102568820
TRN REF NO:D03ZOAC2222302E3 -192,823.66 05:59:22
11.AUG 2022 EFT OUTGOING
71025673NEFT OUT UTR
CITIN22319610621 TRF TO
MONARCH SELF ADHESIVE
FOAMS 7102567320
TRN REF NO:D03ZOAC2222302Du -195,408.00 05:59:22
11.AUG 2022 EFT OUTGOING
71025686NEFT OUT UTR
CITIN22319616330 TRF TO
RBM INDUSTRIES 7102568620
TRN REF NO:D03ZOAC2222302op -198,826.56 05:59:57

10

HI @Kuldeep_Pandey

You can try with this expression

System.Text.RegularExpressions.Regex.Match(YourString,"\b\d{8}(?=NEFT)").Tostring

This expression is based on the NEFT that appeared after the number

image

System.Text.RegularExpressions.Regex.Match(YourString,"\b\d{8}").Tostring

This expression is based on the Length of the string (number)

image

Regards
Gokul

11

HI @Kuldeep_Pandey

Try with this expression

System.Text.RegularExpressions.Regex.Match(YourString,"\b\d{8}(?=NEFT)").Tostring

Another method of expression

System.Text.RegularExpressions.Regex.Match(YourString,"\b\d.*(?=NEFT)").Tostring

image
image544×502 39.7 KB

Regards
Gokul

12

its showing me amount also

13

Based on your input, It will show me only 3 matches record. If you have more share the input with more accurate

@Kuldeep_Pandey

14

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