Printing random characters in Excel when extracting table from a website

[RobertRussell_Monsalud]

Good Day,

I am trying to extract table from a website to excel (csv file) but it resulted into printing random characters. May I know the solution to this one? Thank you.

Best regards,
Robert

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @RobertRussell_Monsalud

Can you please verify contents of datatable in studio before printing it to excel file?

That way you would know what actually is being extracted.

You can either try running the process in debug mode to inspect the data being saved in a datatable by extract activity.

Or you can try to print its contents to verify.

Regards
Sonali

[manasrlenka25 (Manas Lenka)]

Please preview the data table after extraction.

[zoyebmansuri]

Please use regex to verify data in Data table and remove unnecessary characters.