PARSE DATA FILE WITH TWO SECTIONS TO LOAD INTO ORACLE TABLE
Posted on 2011-03-14
I have several data files that will need to be uploaded into Oracle tables, which I have experience with. These files are unique in that they contain data that will be loaded into 2 tables, there is a header section with header columns, followed by a row of data, then the details section, with detail column headers and data that will go into a second table. I want to use perl to parse, and am hoping someone could offer code help with parsing the data file. I have done much research to try to do it in sql_loader, but could not figure out of find a way to parse the data. Thanks so much for any help you can give. Below is what the data table looks like.
33124999|0|02/10/2010 08:17|Air 2|48|1||Bert 2010/143|Gross|02/10/2010 15:10|999999|044444