Shell Programming and Scripting

the output of the sql is:

D|44083669|0192652286|10866|1
D|44083455|0192300318|10867|1

and the utput of the THS_PROF.txt is:

SQL>
SQL> select 'D'||'|'||ciam.external_id||'|'||ciem.external_id||'|'||p.element_id||'|'||
2 case when (p.element_id in (select b.member_id from package_component_members b, package_components c
3 where member_id in (10867,10866,10866,10867,10868,10866,10866,90014,90021)
4 and b.member_type=1
5 and b.component_id in (10459,10458,10658,20105,10499,10647,10810,90014,90022)
6 and c.component_id=b.component_id)) then '1'
7 end "A"
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
10 and ciem.subscr_no=p.parent_subscr_no
11 and p.billing_account_no=c.account_no
12 and c.account_no=ciam.account_no
13 and c.bill_period='G08'
14 and ciem.external_id_type=1
15 and ciam.external_id_type=1
16 and ciem.external_id_type=ciam.external_id_type
17 and p.element_id in (select b.member_id from package_component_members b, package_components c
18 where member_id in (10867,10866,10866,10867,10868,10866,10866,90014,90021)
19 and b.member_type=1
20 and b.component_id in (10459,10458,10658,20105,10499,10647,10810,90014,90022)
21 and c.component_id=b.component_id);
D|44083669|0192652286|10866|1
D|44083455|0192300318|10867|1
SQL>
SQL> spool off;


But i dont want THS_PROF.txt to be created jus 2 files corresponds to 2 rows of the query.

Try adding

Code:

sed 's\spool /SYSTEM/custom/modules/testing/THS_PROF.txt\//g'

before

Code:

SRCFILE="THS_PROF.txt"
COUNT=0
sed '1d' $SRCFILE | while read X; do
((COUNT=COUNT+1))
OUTFILE="file${COUNT}_"`echo "$X" | awk -F"\t" '{ print $2 }'`"_"`date +%Y%m%d%H%M%S`".txt"
echo "$X" > $OUTFILE

This will attempt to remove the line...I'm not sure though if this will be successful. I cannot test it right now.

Error

sed: Function s\spool /SYSTEM/custom/modules/testing/THS_PROF.txt\//g cannot be parsed.

Code:

sed 's\spool /SYSTEM/custom/modules/testing/THS_PROF.txt\\g'

My bad...Try again

Could you plz tell me wht this line of code can actually do???????????????????

Same thing sed: Function s\spool /SYSTEM/custom/modules/testing/THS_PROF.txt\\g cannot be parsed.

How can i modify this sed stmt to create just 1 file for all the account nos with the value passed as argument should be in the file name in place of account no like THS_PROF_G03_20090114155816.txt where G03 is the value passed as argument:


SRCFILE="THS_PROF.txt"
sed '1d' $SRCFILE | while read X; do
OUTFILE="THS_PROF_"`echo "$X" | awk -F"\t" '{ print $2 }'`"_"`date +%Y%m%d%H%M%S`".txt"
echo "$X" > $OUTFILE

Ooppss...What was I thinking..Try this:

Code:

sed 's-spool /SYSTEM/custom/modules/testing/THS_PROF.txt--g'

This will delete the line spool /SYSTEM/custom/modules/testing/THS_PROF.txt

Kindly rephrase your last post. I can't understand it.