in reply to Re^2: regular expression to get the tablename.column_name
in thread regular expression to get the tablename.column_name

If you're on windows, use double quotes. *nix variant, single quotes. You obviously want:

perl -nle '/TABLE;(.*)/?($t=$1):/COLUMN;([^;]*)/&&print(qq{$t.$1})' fi +le1.txt


--chargrill
s**lil*; $*=join'',sort split q**; s;.*;grr; &&s+(.(.)).+$2$1+; $; = qq-$_-;s,.*,ahc,;$,.=chop for split q,,,reverse;print for($,,$;,$*,$/)