Extract data

Address
How to extract the address till usa

1 Like

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

2 Likes

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

Actually this is a pdf data

1 Like

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

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

Exactly what I wanted to do…

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

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

Actually I am getting 1 continuous line as output

Then Address I splited in 4 lines

Refer the image Which I have posted

can i have a view on that output
@Sweety_Girl


This is the pdf

txt
And this is the output

I need the data under the bill to:

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