Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    25

    Unanswered: Extracting a string from a line

    Hi Experts,

    I want to extract the table name and the database names using perl scripts from a file which contains the following

    select D.dept_id,E.emp_name, E.emp_addr from department:t_dept D,employee:t_emp E where D.emp_id = E.dept_id

    here department and employee are the database names
    and t_dept and t_emp are the tablenames

    Thanks in advance.

    Regards,
    Poornima.

  2. #2
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    Does this work:

    Code:
    perl -pe "$_=join(qq{\t}, /\w+:\w+/g).qq{\n};" filename filename ...
    If you can manually inspect the results, a regular expression is fine. Otherwise you need to parse the SQL, which is not a trivial matter.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •