I created a transform for Zillow and I got stumped. Almost all of the rows showed acreage. One of the rows showed square feet. I need EDT to take any rows that shows the word square feet and do 2 things. I need it to remove the words square feet and then take the number that is in that row and divide that number by 43,560 to show the acreage. Can somebody help? Thank you.
Zillow.transform (83.0 KB)
Just uploaded the transform, if that helps. Thanks
You can:
- use Split Cols c11n to separate out the number from the units (acres/sqft)
- use If to set a sqft→acres conversion factor (1 if already in acres)
- use Calculate to do the conversion
Zillow2.transform (83.7 KB)
Note that you can use the Units transform if everything is in the same units.
I’m still confused. Is there a way to make the IF find the sqft lot text in the Acres column and divide the number in the same cell by 43,560? Then I could add a replace that takes out the sqft lot text after.
Yes, you could use If and contains.
Not if it has also got the sqft text in.
What is wrong with the solution supplied?