st: RE: converting files

[Nick Cox <n.j.cox@durham.ac.uk>]

This looks programmable but not trivial. -file- is your friend. 

Nick 
n.j.cox@durham.ac.uk 

Jenniffer Solorzano Mosquera

I'm trying to convert several company reports into stata readable
formats. The type of the files is txt and each file correspond to a
different company. The report had different sections like, "key
financials", "balance sheets", etc,.. and some companies can have more
or less years depending on the available information on the database. In
other words, each file doesn't have an order because it has "sections"
so it is not possible for example to have columns for each
variable...Not in the way the files are specifiied.

Is there any way to export each report in a readable database... It
would be possible to identify the names of each variable in each file
and then extract the information to put it on an organized dataset? This
is the Amadeus database.
Thanks for your info!

The file is similar to the following:

No of recorded shareholders 1
No of recorded subsidiaries 0
Industry classification [Maximize this section]  [Hide this section] 
Maximize this section Remove this section
   Trade description (original language)
Aktiebolaget ska vara mekanisk verkstadsrörelse samt därmedförenlig
verksamhet. 
   SNI-SE 2007 code(s)
   Primary code :
28410 - Manufacture of metal forming machinery 
   NACE Rev. 2 code(s)
   Primary code :
2841 - Manufacture of metal forming machinery 
   NAICS 2007 code(s) {derived from NACE Rev.2 codes}
   Core code :
3335 - Metalworking Machinery Manufacturing 
   Primary code :
333513 - Machine Tool (Metal Forming Types) Manufacturing 
   US SIC code(s) {derived from NACE Rev.2 codes}
   Core code :
354 - Metalworking machinery and equipment 
   Primary code :
3542 - Machine tools, metal forming types 
Key financials & employees [Maximize this section]  Options | [Hide this
section]  Maximize this section Remove this section
Columns
Unconsolidated
31/12/2010
EUR 31/12/2009
EUR 31/12/2008
EUR 31/12/2007
EUR 31/12/2006
EUR 31/12/2005
EUR 31/12/2004
EUR 31/12/2003
EUR 31/12/2002
EUR 31/12/2001
EUR

Exchange rate: EUR/SEK 12 months
Local GAAP
0.11154 12 months
Local GAAP
0.09754 12 months
Local GAAP
0.09200 12 months
Local GAAP
0.10592 12 months
Local GAAP
0.11062 12 months
Local GAAP
0.10651 12 months
Local GAAP
0.11099 12 months
Local GAAP
0.10883 12 months
Local GAAP
0.10805 12 months
Local GAAP
0.10817
          
Op. Revenue (Turnover) 3,215,102 4,183,658 5,841,211 6,323,283 6,975,184
6,115,635 5,472,625 7,137,793 11,149,250 10,399,964
P/L before tax -592,605 -641,044 202,024 -368,587 311,065 398,144
-1,166,625 195,793 619,571 890,795
P/L for period [= Net Income] -592,605 -679,670 163,109 -585,079 186,838
449,483 -898,804 1,850 -15,992 -7,464
Cash flow -456,751 -374,462 n.a. n.a. n.a. n.a. -427,648 470,056 453,819
471,954
Total assets 1,627,907 2,412,595 3,211,497 4,039,737 4,346,174 4,640,542
3,981,685 5,157,008 6,412,569 6,026,793
Shareholders funds -33,685 488,781 1,083,624 1,059,794 2,150,023
2,197,036 1,777,740 1,950,638 1,826,729 1,585,150


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/