Hello,
Hope every one had a good Chrismas.
I successfully scrape a website.
However, some data may have a 0 as first digit (see screenshot below) and when exporting as CSV, the leading 0 is removed.
I found a workaround.
I'm just wondering if there is something I can do in webscraper to keep the 0 when exporting.
Thank you
David
Not really, as this is more to do with the Excel (or whatever you are using to open the file) setting than Web Scraper, as the zero is in the file, just the program decides not to display it.
Ya I believe WS will just scrape as is, and does not remove 0s. As mentioned by Webber, it is probably your Excel settings. Try formatting the column as "text" and it should display correctly.
Webbe, Leemeng,
Honesly, these are the answers I was expecting. Nothing to do with WS.
I'll continue with my workaround: changing the extension to txt, opening in Excel and setting the column as Text.
Thank you both
