You won the lottery and decided to invest the 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 so because the file doesn't have a precise structure. Fortunately, you have the JavaScript step, which will help you to give the file some structure.
Create a new transformation.
Get the sample file from Packt site and read it with a Text file input step. Uncheck the Header checkbox and create a single...