Search Results

perl -ne 'print "$1\n" if /((?:ROW|COLUMN)_\w+)/' $filename

perl -lne '$x=" "; /(crash_report_\d+)/ && ($x = "$1 "); while(/(generate_check_\d+)/g){ $x .= "$1 " }; ($x !~ /^\s+$/) && print $x' file

Yes, you can search for records containing pattern: crash_report & generate_check and work only on them:
awk -F'=' '/crash_report/ && /generate_check/ {gsub(/"|&#xA\;&#xA\;.*|&#xA\;/,OFS,$3);sub(/^...

awk -F"\"|&#xA\;" '{print $4,$5}' xmlfile
crash_report_0013 generate_check_0020 generate_check_0022
crash_report_1001 generate_check_1001 generate_check_102 generate_check_0050
crash_report_4211...

perl -ne '/(crash_report_\d+)/ && print "$1 "; while(/(generate_check_\d+)/g){print "$1 "}; print "\n"' file

awk -F'=' '{gsub(/"|\&#xA\;\&#xA\;.*|\&#xA\;/,OFS,$3);sub(/^ /,X,$3);$0=$3}1' file

Give it a try, suvendu4urs. Take a look at the sample program for WriteExcel in CPAN (http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.38/lib/Spreadsheet/WriteExcel.pm). Let us know what...

Your example is incomplete and a little vague. If I've guessed correctly at what you want, the awk script below may do what you want:
awk '
/^HLD_EA/ {
if(out) print out
out = $0...

Please show us your attempts at the solution.

grep "documentation" file | grep -o -E "HLD_[0-9a-zA-Z_]+"

perl -ne 'if (/documentation/){while(/(HLD_\w+)/g){print "$1"};print "\n"}' file

And yes, you may use Spreadsheet::WriteExcel module to write to an xls file.