Data Scraping with specific letters

[RPAnoob]

Hi! Can someone help me, cant find information about it…
When I’m extracting data to a Data Table using Data Scraping if there is a letter in the lines “Õ” the position of the rows destroyed. Look at the screenshot. How can I fix this, exclude the reading of the letter or something?

[Srini84 (Srinivas)]

@RPAnoob

Which activity you are using to save to excel

Is it Read Range activity or Write CSV activity

Thanks

[RPAnoob]

ExcelWriteRange activity, try another?

[Srini84 (Srinivas)]

@RPAnoob

Can you try with write CSV and share the result

Thanks

[RPAnoob]

Same(

[Srini84 (Srinivas)]

@RPAnoob

Is it public site you are trying to extract, If so share the URL

So that i can try

Thanks

[RPAnoob]

Yeah, ofc, this is pdf file, here one of the list.B1-2.pdf (35.0 KB)

[Yoichi]

Hi,

Perhaps you should use Read PDF Text activity in this case.
Hope the following helps you.

Sample20200622-4.zip (58.3 KB)

Regards,

[RPAnoob]

Thank you! That is good solution)

[RPAnoob]

Yoichi, one more question please? What can i do if its multiple pages in pdf?B1-2.pdf (85.6 KB)

[Yoichi]

Hi,

In this case, perhaps we should get text pege by page as the following sample.

Sample20200622-4v2.zip (152.4 KB)

Regards,

[RPAnoob]

You know, that you are the best?!)