Unable to extract these values from PDF

Help
, ,
1

Hi Everyone,

I have a .PDF file.
i want to extract - certain fields

image
this format remains same but the values gets different.

  1. i did -read .pdf, saved to text file
    2.regex for 1st field is done for the 2nd one -“Platform Type”
    image

Please help me

Regards,
Seema

2

@Seema_S - is it possible to share the text ? When you are reading the psf please use preserve format to true that will give better result.

3

Preserve - for pdf read activity right, okay done
Sure i wil share the text file
SCR_PDF.txt (13.9 KB)

4

@Seema_S - Thanks for sharing the text file. So you just want the platform type from this right? If yes, then please check below…

image
image541×508 20 KB

5

@prasath17
thank you for the regex.
is it a regex tool? can you please tell me from where i can get it? it will be more helpful.
i want other fileds as well.
image

also i have to extract above all values
Position A, position B,position C,
position A Type, position B Type, position C Type.

Regards,
Seema

6

@Seema_S - It’s .NET Regex Tester - Regex Storm … For my Regex I always use this…and it’s works perfectly with UiPath…

Let me look at your other fields…

7

@Seema_S - Could you please see below… I did not find the same text as you shown in your screenshot…looks like its different file…

image
image856×594 29.7 KB

8

@prasath17
oh okay
yes its different, but still you have found the EFEM Type. but i want the 1st one - i.e
EFEM Type :6.4E

well i went to the link .NET Regex. but their how shall i find the regex… could you please help me with how to use this tool

9

@Seema_S - You have to paste your text and write the regex…

Please refer this post on Regex…

Best Video in youtube

2 Likes
10

@Seema_S - Here you go…

image
image639×699 37.3 KB

11

@prasath17
Hey i want them one by one, not as a whole…
Position A,
position B,
position C,
position A Type,
position B Type,
position C Type
Chambar code A

All the values corresponding to them should be save in different different strings.
Example
Position A : XYZ
then i want only XYZ

i dont know how to get regex :frowning:

12

You didn’t mentioned anywhere in your requirement before, If you could provide a clear requirement (next time) it would be easy for us to provide the right solution…

Sure, i will extract only values for the above strings…

13

So Sorry , sure will take care next time.
Thanks Prasanth

14

Hi .@Seema_S … No worries…Cool…

Here you go…

Regex Approach: First I took everything in between “Order Configuration and Chamber Code B” and then I took that output & created another Regex to extract all the string after :

image
image1215×698 142 KB

Using System.Text.RegularExpressions.Regex.Matches wrote a assign statement to extract the MatchValues.

Then using ForEach use to iterate through the matches to printed the required output.

Output:
image

XAML: Regex_Seema.zip (37.9 KB)

Hopes this helps…