[J.Poornima]

Hi Experts,

I want to extract the table name and the database names using shell 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.

[radoulov]

With GNU grep:

grep -o '[[:alnum:]]*:[[:alnum:]_]*' data

Or use Awk for more flexible manipulation:

awk 'NF>1{sub(/.*,/,"");printf "database: %s, table_name: %s\n",$1,$2}' FS=":" RS=" " data