Extract data

Help
1

Address
How to extract the address till usa

1 Like
2

Hello @Sweety_Girl
If you remembered level 3 assignment on academy .where we extract client information.
You can do just like that

2 Likes
3

Hi
@Sweety_Girl hope you are doing good
Fine we can get that use GET TEXT activity or with SCREEN SCRAPPING method from design tab in uipath studio
Cheers @Sweety_Girl

4

Actually this is a pdf data

1 Like
5

If it is PDF data you can save the document and read it as PDF text

6

Fine
we can either use READ PDF or READ PDF WITH OCR and get the output with a variable of type string and do some string manipulation so that we can get the address details
or if the address is readily visible when the pdf is opened
then
–use a START PROCESS activity and pass the file path of the pdf as input
–next to that use SCREEN SCRAPPING METHOD from design tab in studio and get the output as a string variable. Use OCR method in screen scrapping

kindly try this and let know for any queries or clarification
Cheers @Sweety_Girl

7

Exactly what I wanted to do…

How can I do string manipulation or regex in that complicated text

8

we need to look on the string output that we obtain
based on that we can use REGEX expression or SPLIT method to get the address we need

@Sweety_Girl

9

Actually I am getting 1 continuous line as output

Then Address I splited in 4 lines

10

Refer the image Which I have posted

11

can i have a view on that output
@Sweety_Girl

12

pdf
pdf749×167 31.7 KB

This is the pdf

txt
And this is the output

13

I need the data under the bill to:

14

Hi @Sweety_Girl,
If you want to get all the texts after ‘Bill To:’ , please try with the below -
Regex.Match(Your_Output_String_Variable, “(?<=Bill\sTo\s:\s*).*[\w+\s\n,./;@$#()”“]+”).Value

Thanks & Regards,
Apurba