I am practicing creating an automation to properly scrape a number of items off of a real estate listings website.
I am scraping the square footage of each of the properties and often times a handful of them contain no data and are logged as so in the Immediate table as:
The output provides this: Assign: String cannot be of zero length
I’ve tried a number of ways to fix this to a 0 so I can pull out 0 values later from my scrape… but no luck.
I created a new variable Sqft set as a double.
The original assign I use under this if that detects whether the value is Null or Empty is the following Assign:
Sqft = Convert.ToDouble(row("Sqft").ToString.Replace("","0").Trim)
Additionally I tried in an Assign
Sqft = Cint(row("Sqft").ToString.Replace("","0").Trim)