I am using the premade "write from database" to grab some information relating to specific zipcodes. Unfortunately, helium scraper takes any zipcode that begins with a "0" (such as 08358- Cherry Hill) and drops any zero before the first significant number (08358 -> 8358, 00217 -> 217, etc.).
How can I force the database to always include the necessary digits when running a query?
Thanks!
Write From Database
Re: Write From Database
Hi,
Did you set your zip code column data type to Integer or any other numeric type? Try recreating the table and setting it to Memo or Text instead.
Did you set your zip code column data type to Integer or any other numeric type? Try recreating the table and setting it to Memo or Text instead.
Juan Soldi
The Helium Scraper Team
The Helium Scraper Team