the output of THS_PROF_G03_20090114192352.txt is:
SQL> $
SQL>
SQL> select 'D'||'|'||ciam.external_id||'|'||ciem.external_id||'|'||p.e
lement_id||'|'||$
SQL> select 'D'||'|'||ciam.external_id||'|'||ciem.external_id||'|'||p.element_id||'|'||
2 case when (p.element_id in (select pcm.member_id from package_comp
onent_members pcm, package_components pc$
2 case when (p.element_id in (select pcm.member_id from package_component_members pcm, package_components pc
3 where member_id in (10867,10866,10866,10867,10868,10866,10866,9001
4,90021)$
3 where member_id in (10867,10866,10866,10867,10868,10866,10866,90014,90021)
4 and pcm.member_type=1$
4 and pcm.member_type=1
5 and pcm.component_id in (10459,10458,10658,20105,10499,10647,10810
,90014,90022)$
5 and pcm.component_id in (10459,10458,10658,20105,10499,10647,10810,90014,90022)
6 and pc.component_id=pcm.component_id)) then '1'$
6 and pc.component_id=pcm.component_id)) then '1'
7 end "A"$
7 end "A"
8 from customer_id_acct_map ciam, customer_id_equip_map ciem, produc
t p, cmf c, dual$
8 from customer_id_acct_map ciam, customer_id_equip_map ciem, product p, cmf c, dual
9 where ciam.account_no=p.billing_account_no$
9 where ciam.account_no=p.billing_account_no
10 and ciem.subscr_no=p.parent_subscr_no$
10 and ciem.subscr_no=p.parent_subscr_no
11 and p.billing_account_no=c.account_no$
11 and p.billing_account_no=c.account_no
12 and c.account_no=ciam.account_no$
12 and c.account_no=ciam.account_no
13 and c.bill_period='G03'$
13 and c.bill_period='G03'
14 and ciem.external_id_type=1$
14 and ciem.external_id_type=1
15 and ciam.external_id_type=1$
15 and ciam.external_id_type=1
16 and ciem.external_id_type=ciam.external_id_type$
16 and ciem.external_id_type=ciam.external_id_type
17 and p.element_id in (select pcm.member_id from package_component_m
embers pcm, package_components pc$
17 and p.element_id in (select pcm.member_id from package_component_members pcm, package_components pc
18 where member_id in (10867,10866,10866,10867,10868,10866,10866,9001
4,90021)$
18 where member_id in (10867,10866,10866,10867,10868,10866,10866,90014,90021)
19 and pcm.member_type=1$
19 and pcm.member_type=1
20 and pcm.component_id in (10459,10458,10658,20105,10499,10647,10810
,90014,90022)$
20 and pcm.component_id in (10459,10458,10658,20105,10499,10647,10810,90014,90022)
21 and pc.component_id=pcm.component_id);$
21 and pc.component_id=pcm.component_id);
D|44083641|0192300160|10866|1$
D|44083641|0192300160|10866|1
D|44083641|0192300160|10867|1$
D|44083641|0192300160|10867|1
SQL> spool off;$
SQL> spool off;
out of which i jus want:
D|44083641|0192300160|10866|1
D|44083641|0192300160|10866|1
D|44083641|0192300160|10867|1
D|44083641|0192300160|10867|1
but without $.
i tried sed but prob couldnt be resolved.