I would like to know how to do a parse of a txt with the following structure:
Each item in the file is separated by the TAB key.
The columns are:
purchaser name, item description, item price, purchase count, merchant address, merchant name.
purchaser name item description item price purchase count merchant address merchant name
Jo?o Silva R$10 off R$20 of food 10.0 2 987 Fake St Bob's Pizza
Amy Pond R$30 of awesome for R$10 10.0 5 456 Unreal Rd Tom's Awesome Shop
Marty McFly R$20 Sneakers for R$5 5.0 1 123 Fake St Sneaker Store Emporium
Snake Plissken R$20 Sneakers for R$5 5.0 4 123 Fake St Sneaker Store Emporium
After analyzing this data I need to send to a normalized database and with the respective tables created.
See Question&Answers more detail:os