make it simple!!!

vidyadhar85 · August 21, 2008, 1:23am

i am having following DML file i want to extract only highlighted area using sed or awk oneliner..

decimal("�") fuba_nbr; /* INTEGER NOT NULL*/
date("YYYY-MM-DD")("�") xprn_dte = NULL(""); /* DATE*/
date("YYYY-MM-DD")("�") effv_dte = NULL(""); /* DATE*/
date("YYYY-MM-DD")("�") load_dte; /* DATE NOT NULL*/
string("�", maximum_length=1) dbt_card_lnk_ind = NULL(""); /* CHAR("|")/
string("�", maximum_length=1) acct_rltps_ind = NULL(""); / CHAR("|")/
decimal("�", maximum_length=6) br_nbr = 0; / DECIMAL("|")/
string("�", maximum_length=9) ofcr_nbr = NULL(""); / CHAR("|")/
date("YYYY-MM-DD")("�") last_od_dte = NULL(""); / DATE*/
decimal("�", maximum_length=17) curr_bal_amt = 0; /* DECIMAL("|")/
string("�", maximum_length=1) acct_type_cde = NULL(""); / CHAR("|")/
decimal("�", maximum_length=8) pr_cde = 0; / DECIMAL("|")/
string("�", maximum_length=20) cust_nme = NULL(""); / CHAR("|")/
string("�", maximum_length=3) bnk_id = NULL(""); / CHAR("|")/
decimal("�", maximum_length=4) city_cde = 0; / DECIMAL("|")/
decimal("�", maximum_length=4) rgn_cde = 0; / DECIMAL("|")/
date("YYYY-MM-DD")("�") last_dps_dte = NULL(""); / DATE*/
decimal("�", maximum_length=17) last_dps_amt = 0; /* DECIMAL("|")*/

i wrote the following sed command for this ..
it works fine but its too complex i guess.. can any one help me out to make it simpler..

thanks in advance..
vidya..

Annihilannic · August 21, 2008, 2:01am

How about:

sed 's/.*) \([^ ;]*\).*/\1/g'

vidyadhar85 · August 21, 2008, 2:20am

oh great thanks..