Help with printing output format from a file

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

Hi,

I need help in printing data in below format from file extensions with .dml, i have listed details below

file name is test_temp.dml, location in /home/users/test01/test_temp.dml

file content:

 sample_type=
record
  decimal(",") test_type;
  date("DD-MM-YYYY")(",") test_date = NULL("");
  string(",") test_time = NULL("");
  decimal(",") test_duration;
  string(",") test1_band = NULL("");
  string(",") test2_band = NULL("");
  string(",") test3_band = NULL("");
  decimal(",") test_charge;
  decimal(",") test1_charge;
  decimal(",") test2_charge;
  string(",") testa_type = NULL("");
  string(",") testb_digits = NULL("");
  string(",") testc_digits = NULL("");
  string(",") test_field_A = NULL("");
  string(",") test_field_B = NULL("");
  string(",") test_field_C = NULL("");
  string(",") test_field_D = NULL("");
  string(",") test_field_E = NULL("");
  decimal(",") test_PPP;
  string(",") Test_source_cc = NULL("");
  string(",") test_field_xcv = NULL("");
  string(",") test_call = NULL("");
   decimal("\n") test_cycle;
end;

required outpout format:

test_type;test_date;test_time;test_duration;test1_band;test2_band;test3_band;test_charge;test1_charge;test2_charge;testa_type;testb_digits;testc_digits;test_field_A;test_field_B;test_field_C;test_field_D;test_field_E;test_PPP;Test_source_cc;test_field_xcv;test_call;test_cycle

last column should not have the semi colon.

Thanks in advance,
AAHinka

2

Try:

awk 'NF>1{s=s (s?";":x) $2; sub(/;$/,x,s)} END{print s}' file

or

awk 'NF>1{sub(/;$/,x,$2); print $2}' file | paste -sd\; -
3

Thank you, it worked....

 
awk 'NF>1{s=s (s?";":x) $2; sub(/;$/,x,s)} END{print s}'