title: shell script to extract multiline data out of a text file with regex
body: <p>i am trying to extract some specific data out of a text file using regular expressions with shell script</p>
  
  <p>that is using a multiline grep .. and the tool i am using is pcregrep so that i can get compatibility with perl's regular expressions</p>
  
  <pre><code> [58]Walid Chamoun Architects WLL
       * [59]Map
       * [60]Website
       * [61]Email
       * [62]Profile
       * [63]Display Ad
  
     Walid Chamoun Architects WLL
  
     PO Box:
            55803, Doha, Qatar
  
     Location:
            D-Ring Road, New Salata Shamail 40, Villa 340, Doha, Qatar
  
     Tel:
            (00974) 44568833
  
     Fax:
            (00974) 44568811
  
     Mob:
            (00974) 44568822
  
       * Accurate Budget Costing
       * Eco-Friendly Structural Design
       * Exclusive &amp; Unique Design
       * Quality Architecture &amp; Design
  
  Company Profile
  
     Walid Chamoun Architects (WCA) was founded in Beirut, Lebanon, in 1992,
     committed to the concept of fully integrated design-build delivery of
     projects. In late '90s, company established in-house architectural and
     engineering services. As a full service provider, WCA expanded from
     multi-family projects to industrial and office construction, which
     added development services, including site acquisition and financing.
     In 2001, WCA had opportunity and facilities to experience European
     market and establish office in Puerto Banus, Marbella, Spain. By 2005,
     WCA refined its structure to focus on specific market segments and new
     office was opened in Doha, state of Qatar. From a solid foundation and
     reputation built over eighteen years, WCA continually to provide
     leadership in design-build through promotion of benefits and education
     to its practitioners.
     Project Planning: Project planning and investigation occurs before
     design begins has greatest impact on cost, schedule and ultimately the
     success of project. Creativity in Design: You can rely on our in-house
     designers for design excellence in all aspects of the project. Our
     designs have received recommendations and appreciations on national and
     international levels. Creativity in Execution: Experienced in close
     collaboration with the designers as part of the integrated team, our
     construction managers, superintendents and field staff create value
     throughout the project. Post Completion Services: Your needs can be
     served through our skills and experience long after the last
     construction crew has left the site. Performance: Corporate and
     institutional clients, developers and public agencies repeatedly select
     WCA on the basis of its consistent record of performance excellence.
     Serving clients throughout the Middle East and GCC, WCA provides
     complete planning for architectural, interior design and construction
     on a single-responsibility basis. Our expertise spans industrial,
     commercial, institutional, public and residential projects. Benefits of
     Design-Build: Design-build is a system of contracting under which one
     entity performs both design and construction. Benefits of design-build
     project delivery include: Single point responsibility Early knowledge
     of cost Time and Cost savings
  
     Classification:
            Architects - [64]Architects
  
     [65]Al Ali Consulting &amp; Engineering
       * [66]Map
       * Website
       * Email
       * Profile
       * Display Ad
  
     Is this your company?
     [67]Upgrade this free listing here
  
     PO Box:
            467, Doha, Qatar
  
     Tel:
            (00974) 44360011
  
  Company Profile
  
     Classification:
            Architects - [68]Architects
  
     [69]Al Gazeerah Consulting Engineering
       * [70]Map
       * Website
       * Email
       * Profile
       * Display Ad
  
     Is this your company?
     [71]Upgrade this free listing here
  
     PO Box:
            22414, Doha, Qatar
  
     Tel:
            (00974) 44352126
  
  Company Profile
  
     Classification:
            Architects - [72]Architects
  
     [73]Al Murgab Consulting Engineering
       * [74]Map
       * Website
       * Email
       * Profile
       * Display Ad
  
     Is this your company?
     [75]Upgrade this free listing here
  
     PO Box:
            2856, Doha, Qatar
  
     Tel:
            (00974) 44448623
  
  Company Profile
  
     Classification:
            Architects - [76]Architects
  References
  
     Visible links
     1. http://www.qatcom.com/useraccounts/login
     2. http://www.qatcom.com/useraccounts/register
     3. http://www.qatcom.com/
     4. http://www.qatcom.com/
     5. http://www.qatcom.com/qataryellowpages/map-of-doha
     6. http://www.qatcom.com/qataryellowpages/about-qatcom
     7. http://www.qatcom.com/qataryellowpages/advertise-with-qatcom
     8. http://www.qatcom.com/qataryellowpages/advertiser_testimonials
     9. http://www.qatcom.com/useraccounts/login
    10. http://www.qatcom.com/useraccounts/register
    11. http://www.qatcom.com/contact-qatcom
    12. http://www.qatcom.com/qataryellowpages/companies
    13. http://www.qatcom.com/classifications/index/A
    14. http://www.qatcom.com/classifications/index/B
    15. http://www.qatcom.com/classifications/index/C
    16. http://www.qatcom.com/classifications/index/D
    17. http://www.qatcom.com/classifications/index/E
    18. http://www.qatcom.com/classifications/index/F
    19. http://www.qatcom.com/classifications/index/G
    20. http://www.qatcom.com/classifications/index/H
    21. http://www.qatcom.com/classifications/index/I
    22. http://www.qatcom.com/classifications/index/J
    23. http://www.qatcom.com/classifications/index/K
    24. http://www.qatcom.com/classifications/index/L
    25. http://www.qatcom.com/classifications/index/M
    26. http://www.qatcom.com/classifications/index/N
    27. http://www.qatcom.com/classifications/index/O
    28. http://www.qatcom.com/classifications/index/P
  </code></pre>
  
  <p>for a sample data like this, i am trying to grab the details of companies namely</p>
  
  <pre><code>company name
  po box
  Tel
  fax
  mobile
  company profile 
  </code></pre>
  
  <p>into a .csv file
  i am new to regular expressions and linux too..
  all i could manage to get was something like this</p>
  
  <pre><code>\[\d*\][^\.]*[\(\d*\)\s\d*)]
  </code></pre>
  
  <p>can anyone help me out with this please..</p>
  
  <p>improvements:</p>
  
  <p>i figured out something like this</p>
  
  <pre><code>$ awk '/^\[/ &amp;&amp; ! /Upgrade this free listing/ {print $0} /:$/ &amp;&amp; ! /Classification/ {printf $0 ;  getline x ; print x}' file
  </code></pre>
  
  <p>but that still isn't what i want it to be...</p>