Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Error ???

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Error ???
# 1  
Old 03-07-2006
Error ???
Hi all,

What did I do wrong ???

I have file record.dat

DLMQ|02/26/2006 01.00.00.000|||||Case CASE_ID=1111117777 STLITE ACCT_ID=1112227777 PREM_ID= PER_ID=1113337777
DLMQ|02/26/2006 01.10.00.000|||||Case CASE_ID=1111118888 SVCPLN ACCT_ID=1112228888 PREM_ID= PER_ID=1113338888
DLMQ|02/26/2006 01.00.00.000|||||PayPlan PP_ID=1111117777 ACCT_ID=STLITE
DLMQ|02/26/2006 01.10.00.000|||||PayPlan PP_ID=1111118888 ACCT_ID=SVCPLN
DLMQ|02/26/2006 01.00.00.000|||||FieldOrder FO_ID=1111117777 PREM_ID=STLITE
DLMQ|02/26/2006 01.10.00.000|||||FieldOrder FO_ID=1111118888 PREM_ID=SVCPLN
DLMQ|02/26/2006 01.00.00.000|||||Literature LIT_ID=1111117777 ACCT_ID=STLITE PER_ID=1112227777
DLMQ|02/26/2006 01.10.00.000|||||Literature LIT_ID=1111118888 ACCT_ID=SVCPLN PER_ID=1112228888
DLMQ|02/26/2006 01.00.00.000|||||FieldOrder FO_ID=1111117777 PREM_ID=STLITE
DLMQ|02/26/2006 01.10.00.000|||||FieldOrder FO_ID=1111118888 PREM_ID=SVCPLN
DLMQ|02/26/2006 01.00.00.000|||||FieldActivity FA_ID=1111117777 1113337777 FO_ID=STLITE SP_ID=1112227777
DLMQ|02/26/2006 01.10.00.000|||||FieldActivity FA_ID=1111118888 1113338888 FO_ID=SVCPLN SP_ID=1112228888
KLMQ|02/26/2006 00:08:07|||||StartStop 10031
LMWC|02/26/2006 00:07:28|||||FieldOrderHistory Modify 10021 20022 30023 40024
CRBM|02/26/2006 00:00:59.983|SAC||7700||
DLMQ|02/26/2006 01.05.00.000|||||CTI-CallTimer
BBS7|02/26/2006 0:02:06|||||OutageStatus SP_ID=293598472
CXT9|02/26/2006 1:09:51|||||OutageTroubleReport Cancel UnknownPremise PREM_ID=3417176263 SP_ID=5823949782 Overload Broken
CXT9|02/26/2006 2:36:31|||||OutageTroubleReport Create UnknownPremise PREM_ID=3417176279 SP_ID=3344936767 Overload Fix
CXT9|02/26/2006 2:36:42|||||OutageTroubleReport Cancel PREM_ID=3417176283 SP_ID=3344936767 Overload Broken
CXT9|02/26/2006 2:36:54|||||OutageTroubleReport Create PREM_ID=3417176287 SP_ID=3344936767 TrimTree Fix
CXT9|02/26/2006 2:37:58|||||OutageTroubleReport Cancel PREM_ID=3417176295 SP_ID=3344936767 Overload Broken
CXT9|02/26/2006 2:39:22|||||OutageTroubleReport Cancel PREM_ID=3417176303 SP_ID=3344936767 Overload Fix
DLLW|02/26/2006 0:00:05|||||OutageTroubleReport Create UnknownPremise PREM_ID=3417176211 SP_ID=3627854455 Fix Broken


Here is my code

#!/bin/ksh
. ./env_setup.sh

cd ${ROOT_PATH}/intermediate
for file in record*.dat; do

grep "|" $file |
sort -t"|" +0 -1 +1 -2 |
awk -F"|" -v root_path=${ROOT_PATH} '{

InCallFlag='N';
WriteFlag='N';
id=$1;
datetime=$2;
location=$3;
ani=$4;
ext=$5;
calllength=$6;
action=$7;
output_file= root_path "/intermediate/id.log";

##looking for $7 have word ID like PREM_ID, ACCT_ID ...
if (action ~ /ID/) {

type = substr(action,1,index(action," ")-1);

mainkey = substr(action,index(action," ")+1,index(substr(action,index(action," ")+1,20)," ")-1);
mainkey = substr(action,index(action," ")+1,index(substr(action,index(action," ")+1,20)," ")-1);
searchspec1 = type mainkey;
searchspec2 = type "Modify " mainkey;
searchspec3 = type "Access " mainkey;
}
printf "%s,%s,%s,%s,%s,%s,%s\n",id,datetime,callcntr,ani,type,mainkey,action >> output_file;

}'

done


I try to get the output like this

CXT9,02/26/2006 2:37:58,,,OutageTroubleReport,Cancel,OutageTroubleReport Cancel PREM_ID=3417176295 SP_ID=3344936767 Overload Brok
en
CXT9,02/26/2006 2:39:22,,,OutageTroubleReport,Cancel,OutageTroubleReport Cancel PREM_ID=3417176303 SP_ID=3344936767 Overload Fix
DLLW,02/26/2006 0:00:05,,,OutageTroubleReport,Create,OutageTroubleReport Create UnknownPremise PREM_ID=3417176211 SP_ID=362785445
5 Fix Broken
DLMQ,02/26/2006 01.00.00.000,,,Case,CASE_ID=1111117777,Case CASE_ID=1111117777 STLITE ACCT_ID=1112227777 PREM_ID= PER_ID=11133377
77
DLMQ,02/26/2006 01.00.00.000,,,FieldActivity,FA_ID=1111117777,FieldActivity FA_ID=1111117777 1113337777 FO_ID=STLITE SP_ID=111222
7777
DLMQ,02/26/2006 01.00.00.000,,,FieldOrder,FO_ID=1111117777,FieldOrder FO_ID=1111117777 PREM_ID=STLITE
DLMQ,02/26/2006 01.00.00.000,,,FieldOrder,FO_ID=1111117777,FieldOrder FO_ID=1111117777 PREM_ID=STLITE
DLMQ,02/26/2006 01.00.00.000,,,Literature,LIT_ID=1111117777,Literature LIT_ID=1111117777 ACCT_ID=STLITE PER_ID=1112227777
DLMQ,02/26/2006 01.00.00.000,,,PayPlan,PP_ID=1111117777,PayPlan PP_ID=1111117777 ACCT_ID=STLITE
DLMQ,02/26/2006 01.05.00.000,,,PayPlan,PP_ID=1111117777,CTI-CallTimer
DLMQ,02/26/2006 01.10.00.000,,,Case,CASE_ID=1111118888,Case CASE_ID=1111118888 SVCPLN ACCT_ID=1112228888 PREM_ID= PER_ID=11133388
88



But if I change code to if (action !~ /ID/) , I still have the same answer ... something is wrong ??? it does not know action ~ /ID/ or action !~ /ID/

anyone know why??
Thanks !
# 2  
Old 03-07-2006
OOp I found my stupid error Smilie

}
printf "%s,%s,%s,%s,%s,%s,%s\n",id,datetime,callcntr,ani,type,mainkey,action >> output_file;

should be

printf "%s,%s,%s,%s,%s,%s,%s\n",id,datetime,callcntr,ani,type,mainkey,action >> output_file;
}


case closed Smilie, how can i delete it Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Print Error in Console and both Error & Output in Log file - UNIX

I am writing a shell script with 2 run time arguments. During the execution if i got any error, then it needs to redirected to a error file and in console. Also both error and output to be redirected to a log file. But i am facing the below error. #! /bin/sh errExit () { errMsg=`cat... (1 Reply)
Discussion started by: sarathy_a35
1 Replies

2. Solaris

Rpcinfo: can't contact portmapper: RPC: Authentication error; why = Failed (unspecified error)

I have two servers with a fresh install of Solaris 11, and having problems when doing rpcinfo between them. There is no firewall involved, so everything should theoretically be getting through. Does anyone have any ideas? I did a lot of Google searches, and haven't found a working solution yet. ... (2 Replies)
Discussion started by: christr
2 Replies

3. Shell Programming and Scripting

What is this error log = hda: irq timeout: error=0x00 and how to solve?

what is this error log = hda: irq timeout: error=0x00 and how to solve? every day upon checking the logs i see this error. hda: irq timeout: error=0x00 hda: irq timeout: error=0x00 hda: irq timeout: error=0x00 hda: irq timeout: error=0x00 hw_client: segfault at 0000000000000046 rip... (3 Replies)
Discussion started by: avtalan
3 Replies

4. UNIX for Dummies Questions & Answers

> 5 ")syntax error: operand expected (error token is " error

im kinda new to shell scripting so i need some help i try to run this script and get the error code > 5 ")syntax error: operand expected (error token is " the code for the script is #!/bin/sh # # script to see if the given value is correct # # Define errors ER_AF=86 # Var is... (4 Replies)
Discussion started by: metal005
4 Replies

5. UNIX for Advanced & Expert Users

ssh error: Error reading response length from authentication socket

Hi - I am getting the error `Error reading response length from authentication socket' when I ssh from my cluster to another cluster, and then back to my cluster. It doesn't seem to affect anything, but it's just annoying that it always pops up and tends to confuse new users of the cluster. I... (1 Reply)
Discussion started by: cpp6f
1 Replies

6. Solaris

fssnap error :snapshot error: File system could not be write locked

Hi Guys. This is part of my filesystem structure : Filesystem size used avail capacity Mounted on /dev/md/dsk/d0 47G 5.2G 42G 12% / /devices 0K 0K 0K 0% /devices ctfs 0K 0K 0K 0% ... (2 Replies)
Discussion started by: aggadtech08
2 Replies

7. AIX

nim mksysb error :/usr/bin/savevg[33]: 1016,07: syntax error

-------------------------------------------------------------------------------- Hello, help me please. I am trying to create a mksysb bakup using nim. I am geting this error, how to correct it ? : Command : failed stdout: yes stderr: no... (9 Replies)
Discussion started by: astjen
9 Replies

8. UNIX for Advanced & Expert Users

VSI-FAX error - Cannot login to server and Connecto error to host

I encounters a VSIFAX related error: vfxstat: Cannot login to server on rsac3: Connect error to host 172.16.1.45: Invalid argument It started happening last night with a core dump. Then we can't start VSIFAX again. I am runing VSI-FAX 4.2 on AIX box (0 Replies)
Discussion started by: b_jin
0 Replies

9. UNIX for Dummies Questions & Answers

awk Shell Script error : "Syntax Error : `Split' unexpected

hi there i write one awk script file in shell programing the code is related to dd/mm/yy to month, day year format but i get an error please can anybody help me out in this problem ?????? i give my code here including error awk ` # date-month -- convert mm/dd/yy to month day,... (2 Replies)
Discussion started by: Herry
2 Replies

10. UNIX for Dummies Questions & Answers

Error: Internal system error: Unable to initialize standard output file

Hey guys, need some help. Running AIX Version 5.2 and one of our cron jobs is writing errors to a log file. Any ideas on the following error message. Error: Internal system error: Unable to initialize standard output file I'm guessing more info might be needed, so let me know. Thanks (2 Replies)
Discussion started by: firkus
2 Replies
Login or Register to Ask a Question