Hola, en el trabajo me han pedido que haga un parsing para un fichero de texto:<br><div style="margin-left: 40px;"><RECORD 1><br>Accession number:2862793<br>Title:Qualification of switchable metal-oxide arresters for a protective level of 1.6 p.u. on Hydro-Quebec's 735 kV system<br>
Authors:Latour, Y. (1); St-Jean, G. (1); Petit, A.; Huynh, N. <br>Author affiliation:(1) Inst. de Res. d'Hydro-Quebec, Varennes, Que., Canada <br>Serial title:IEEE Transactions on Power Delivery<br>Abbreviated serial title:IEEE Trans. Power Deliv. (USA)<br>
Volume:PWRD-1<br>Issue:4<br>Publication date:Oct. 1986<br>Pages:184-93<br>Language:English<br>ISSN:0885-8977<br>CODEN:ITPDE5<br>Document type:Journal article (JA)<br>Country of publication:USA<br>Material Identity Number:J605-1986-004<br>
Abstract:Results of a series of tests on 39 sections of metal-oxide surge arresters from six manufacturers are reported. Ranging from 85 kV to 160 kV in rated voltage, these sections were similar to the devices to be installed on Hydro-Quebec's 735 kV power transmission system. The purpose of the qualification tests was to assess the merits of this type of arrester as a solution to the overvoltage problem encountered on the James Bay part of the power grid following load-shedding operations. The test program was therefore oriented in terms of demonstrating that the surge arresters produce the following three features: they may fail by short circuit in a totally safe manner, i.e. without explosion or fracture from thermal shock to their housing; they will produce a switching surface protective level of 1.6 p.u. (per unit of rated voltage of a 735 kV system, e.g., 1 p.u.=425 kV<sub>rms</sub>, or 1 p.u.=600 kV<sub>crest</sub>) of crest system voltage (960 kV at 5 kA crest); they will withstand a 60 Hz voltage of 1.2 p.u. (510 kV) for the maximum period of 30 s during which they may be switched onto the power system<br>
Number of references:2<br>Inspec controlled terms:power system protection† - †surge protection<br>Uncontrolled terms:switchable metal-oxide arresters† - †surge arresters† - †power transmission system† - †qualification tests† - †overvoltage problem† - †power grid† - †load-shedding† - †short circuit† - †switching surface protective level† - †735 kV † - †85 to 160 kV<br>
Inspec classification codes:B8140C Protection apparatus<br>Numerical data indexing:voltage 7.35E+05 V;voltage 8.5E+04 1.6E+05 V<br>Treatment:Practical (PRA)<br>Discipline:Electrical/Electronic engineering (B)<br></div><br>
Me piden que el mismo se pueda tener en csv o ingresarlo directamente a una BD relacional, he buscado documentación para no reinventar la rueda y he visto que estan:<br><ul><li>Text::CSV=> Pasa de csv a txt, imagino que se pueda hacer a la inversa.</li>
<li>Tie::CSV_File</li><li>Tie::Handle::CSV</li><li>DBD::CSV</li></ul>Mi duda / problema está en que son más de 6 millones de registros en ficheros de cientos de megas, no se exactamente el número de campos, cuando un autor tenga un numero, ese se corresponde con su afiliación por lo que deberian ir juntos en una tabla o fichero nuevo, pero siempre manteniendo todo en una tabla principal.<br>
<br>¿Cual de estos creen que sea el más optimo para trabajar?<br>