I want to read specific text from pdf . How should I read it

Help Studio
, , ,
9

I applied the condition which has been suggested by you guys.
MicrosoftTeams-image (77)

I want the output of employee social number.This is the only section I want output as.

10

Hi @Bhushan_Nagaonkar ,

Can you paste the text here after you read the pdf?, you can jumble the sensitive numbers in case of security issues.

Regards,

1 Like
11

MicrosoftTeams-image (78)

I want the number.

12

@Bhushan_Nagaonkar ,

If you want the social security number which has a hiphen in it then try the following regex expression:

[0-9-]+

This will match numbers with hiphen in it, for eg xxx-xxxx

Regards,

13

The pdf has other data, also this is the only data I want from PDF. How should I do it?
Can you show me in ss format?

Thankyou

14

Hi @Bhushan_Nagaonkar ,

We will not be able to provide a proper regex if the Sample data format is not provided, However check the below regex :

(?<=social security number.*\s*)[\d-]+

image
image980×323 23 KB

2 Likes
15

@Bhushan_Nagaonkar , in the expression provided by @Gokul_Jayakumar , just change the regex pattern and you are good to go.

Assign it to any string variable

System.text.regularExpressions.Regex.Match("Your String","[0-9-]+").Tostring.Trim

Regards,

1 Like
16

It worked thanks.

I just have one question what if I don’t use get text and just want to use readpdf activity and assign it to regex to get the output how should I do it in this case.

17

@Bhushan_Nagaonkar , after you read the pdf pass the extracted string variable directly to the above expression.

Regards,

18

I tried but the output I got was 7 which was of other elements present in doc

19

Im getting an output but this is the error

MicrosoftTeams-image (82)
MicrosoftTeams-image (81)

20

@Bhushan_Nagaonkar ,

You might have missed the + Sign at the end in the pattern.

21

Still same error

22

@Bhushan_Nagaonkar ,

There was also a ( missing in your pattern at the Beginning :slight_smile:

1 Like
23

I will look for it. Sorry for late reply btw.

24

I have one last query. I need help in understanding if there are multiple document and sometime s the format is different how am I supposed to get output from it.

MicrosoftTeams-image (83)
MicrosoftTeams-image (78)

Above are two format. I wont be able to use get text. I will have to use read pdf and then pass read value from it. What is the regex method/condition for this?

@Manju_Reddy_Kanughula @vishal.kp @supermanPunch @ushu @Gokul_Jayakumar

25

Hi,

I guess i have written correct this time but the error is persisting.

MicrosoftTeams-image (84)
MicrosoftTeams-image (85)

26

Hi @Bhushan_Nagaonkar ,

Try this, using a for each loop you can get all the social security number matched:

System.Text.RegularExpressions.Regex.Matches(InputText,"(\d{3}-\d{2}-\d{4})").Item(0).Groups(1)

image

Regards,

1 Like
27

What do those values represent and will the brackets will be included with that

28

@Bhushan_Nagaonkar , the social security number is 9 digits and in the format of xxx-xx-xxxx. Hence this pattern will be matching all the numbers appearing in that format. The brackets unclosing the pattern are just to get it to group 1, you can avoid the brackets in the pattern, the matches will be present in group 0.

If your question was about the square bracket, then just use .string at the end.

Regards,

1 Like