Time for action – changing a list of house descriptions with JavaScript
Suppose you decided to invest some money in a new house. You asked a real-estate agency for a list of candidate houses for you and it gave you this:
... Property Code: MCX-011 Status: Active 5 bedrooms 5 baths Style: Contemporary Basement Laundry room Fireplace 2 car garage Central air conditioning More Features: Attic, Clothes dryer, Clothes washer, Dishwasher Property Code: MCX-012 4 bedrooms 3 baths Fireplace Attached parking More Features: Alarm System, Eat-in Kitchen, Powder Room Property Code: MCX-013 3 bedrooms ...
You want to compare the properties before visiting them, but you're finding it hard to do because the file doesn't have a precise structure. Fortunately, you have the JavaScript step that will help you to give the file some structure.
Create a new transformation.
Get the sample file from the Packt Publishing website, www.packtpub.com, and read it with a Text file input step. Uncheck the Header checkbox...
