Help need !!

hawk004

Hi,
who can help me to convert the following text file from

SCHEDULE SFOPROD#AD_AETL_WILD_DY
OPENS SFOPROD#"^TRIGLOC^acct_actv_wcs.^CLTB^.1"
card000001.wcs.acct_actv_wcs
OPENS SFOPROD#"^TRIGLOC^acct_pan_rollup_wcs.^CLTB^.1"
card000001.wcs.acct_pan_rollup_wcs
OPENS SFOPROD#"^TRIGLOC^auth_wcs.^CLTB^.1"
card000001.wcs.auth_wcs
SCHEDULE SFOPROD#AD_AEXT_OSCR_DY
OPENS SFOPROD#"^TRIGLOC^oscr_xtrct.0000.1"
card000001.thew.oscr_xtrct
SCHEDULE SFOPROD#AD_AEXT_PHTO_MT
OPENS "^TRIGLOC^photosec_xtrct.0000.1"
thew.photosec_xtrct
SCHEDULE SFOPROD#AD_CETL_ACTV_WK
OPENS "^TRIGLOC^activations.^CLTB^.1"
card000001.web.activations

to

SCHEDULE SFOPROD#AD_AETL_WILD_DY   OPENS SFOPROD#"^TRIGLOC^acct_actv_wcs.^CLTB^.1"  card000001.wcs.acct_actv_wcs
SCHEDULE SFOPROD#AD_AETL_WILD_DY   OPENS SFOPROD#"^TRIGLOC^acct_pan_rollup_wcs.^CLTB^.1"  card000001.wcs.acct_pan_rollup_wcs
SCHEDULE SFOPROD#AD_AETL_WILD_DY   OPENS SFOPROD#"^TRIGLOC^auth_wcs.^CLTB^.1"             card000001.wcs.auth_wcs
SCHEDULE SFOPROD#AD_AEXT_OSCR_DY   OPENS SFOPROD#"^TRIGLOC^oscr_xtrct.0000.1"  card000001.thew.oscr_xtrct
SCHEDULE SFOPROD#AD_AEXT_PHTO_MT   OPENS "^TRIGLOC^photosec_xtrct.0000.1"  thew.photosec_xtrct
SCHEDULE SFOPROD#AD_CETL_ACTV_WK OPENS "^TRIGLOC^activations.^CLTB^.1" card000001.web.activations

Online waiting.. any help will be appreciated.

Thanks

hawk004

望高手指点一下，谢谢！

twf_cc

用bash 3 , 系統 FC4, 看看成不成？
#! /bin/bash
j=0
unset out  # out=   is same
IFS='
'; while read a
do
   out="${out}${out:+\t}${a%}"
   (( j++ ))
   [[ $j == 3 ]] && { echo -e "$out"; unset out; j=0;}
done < urfile

hawk004

Thank you! But I need ksh, our system use korn shell. Can someone use awk or sed?


Thanks in advance!

twf_cc

KSH 沒問題， 改成 POSIX 的方式，任何 POSIX 兼容都可以
#! /bin/ksh
j=0
out=
IFS='
'; while read a
do
   out="${out}${out:+"  "}${a%}"
   j=`expr $j + 1`
   [ $j -eq 3 ] && { echo "$out"; unset out; j=0;}
done < urfile

[ 本帖最后由 twf_cc 于 2006-11-1 09:07 编辑 ]

waker

sed -e '/SCHEDULE/{N;N; s/\n//; s/OPENS/&\n/;}' urfile

r2007

我的理解，应该是这样

1. sed -n '/^SCHEDULE/h;/^OPENS/{G;s/\(.*\)\n\(.*\)/\2 \1/;N;s/\n/ /;p}'

复制代码

hawk004

There are multiple OPENS in the first SCHEDULE,  thanks for all the help, but the output is incorrect,

schedule    open    filename
schedule     open    filename

the output from your script some lines changed to
schedule open filename
open filename schedule ....

Can you please keep working on it?

Thanks