UNIX script help


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting UNIX script help
# 1  
Old 06-13-2006
UNIX script help

Hello,

I am new to UNIX shell scripting but I am willing to learn :-)...

I have to use the C shell....

I have to write a script that should do the following:
- Open an input file and read it line by line.
- For each line read, I have to search for a certain pattern. If it was found then I have to ignore the following two lines and read the following line and store it for further processing. Otherwise, I will just read the following line.
- After the previously mentioned hit is found and the following desired line is read, I have to write one line to another output file that is composed of some texts from the previously read files.
- I have to do that till the end of the file.
- I have to automate the process (this is not important and can be delayed).

Please help me.

Thanks in advance.

Example of the input file:

LOADING PROGRAM VERSION 5.1-0

Cont BXX1 2006-06-03 14:49:54

ALARM HISTORY

<HIST> BXX1 MCMU-0 TRANSM 2006-06-03 10:26:56.75
** ALARM ........ RRM_BX
(0330) INCORRECT STATUS
81d 2d 00 96d 11d 0d

<HIST> BXX1 MCMU-0 TRANSM 2006-06-03 10:28:40.73
.. CANCEL ........ RRM_BX
(0330) INCORRECT STATUS
81d 2d 00 96d 11d 0d

Example of the output file:
exemmlm -n BXX1 -c "EX:CMDx=81,CMDy=2,CMDz=00:L;"
exemmlm -n BXX1 -c "EX:CMDx=81,CMDy=2,CMDz=00:L;"
# 2  
Old 06-14-2006
An awk solution:
Code:
$ cat san.txt 
LOADING PROGRAM VERSION 5.1-0

Cont BXX1 2006-06-03 14:49:54

ALARM HISTORY

<HIST> BXX1 MCMU-0 TRANSM 2006-06-03 10:26:56.75
** ALARM ........ RRM_BX
(0330) INCORRECT STATUS
81d 2d 00 96d 11d 0d

<HIST> BXX1 MCMU-0 TRANSM 2006-06-03 10:28:40.73
.. CANCEL ........ RRM_BX
(0330) INCORRECT STATUS
81d 2d 00 96d 11d 0d

$ cat proc.awk 

BEGIN {
   i=0
   }
{
while ((  getline ) > 0)
   {
   if ( $0 ~ /<HIST> BXX1/ )
      {
      getline
      getline
      getline
      COMMAND[i]=$0
      ++i
      }
   }
}

END {
   print
   for (b=0;b<i;b++)
      printf ("exemmlm -n BXX1 -c \"EX:CMDx=%s,CMDy=%s,CMDz=%s:L;\"\n",substr(COMMAND[b],0,2),substr(COMMAND[b],5,1),substr(COMMAND[b],8,2))
}

$ awk -f proc.awk  san.txt>output

$ cat output 

exemmlm -n BXX1 -c "EX:CMDx=81,CMDy=2,CMDz=00:L;"
exemmlm -n BXX1 -c "EX:CMDx=81,CMDy=2,CMDz=00:L;"

# 3  
Old 06-14-2006
Thanks a BUNCH for your help..but...it didnt work...it is giving the following error:
syntax error The source line is 1.
The error context is
<<< BEGIN >>> {i=0}
awk: Quitting
The source line is 1.

I really appreciate your help.
# 4  
Old 06-14-2006
Umm , strange .
Try this sh:
Code:
$cat proc.sh

awk '
{
i=0
while ((  getline ) > 0)
   {
   if ( $0 ~ /<HIST> BXX1/ )
      {
      getline
      getline
      getline
      COMMAND[i]=$0
      ++i
      }
   }
}

END {
   print
   for (b=0;b<i;b++)
      printf ("exemmlm -n BXX1 -c \"EX:CMDx=%s,CMDy=%s,CMDz=%s:L;\"\n",substr(COMMAND[b],0,2),substr(COMMAND[b],5,1),substr(COMMAND[b],8,2))
}
'<san.txt>ouput

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Downloading hdfs file to local UNIX through UNIX script

Hi All , I am very new to unix script.I am aware of unix commands but never put together in unix script level.If any one can suggest me technical guidance in the below scenario that will highly beneficial. Data have been already migrated from mainframe to Hadoop file system(HDFS).HDFS server... (15 Replies)
Discussion started by: STCET22
15 Replies

2. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

Hi all, $ echo $SHELL /bin/bash Requirement - How to pass oracle sql script as argument to unix shell script? $ ./output.sh users.sql Below are the shell scripts and the oracle sql file in the same folder. Shell Script $ cat output.sh #!/bin/bash .... (7 Replies)
Discussion started by: a1_win
7 Replies

3. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

4. Shell Programming and Scripting

FTP from windows to unix server using unix shell script

Hi, Is it possible to ftp a huge zip file from windows to unix server using unix shell scripting? If so what command i need to use. thanks in advance. (1 Reply)
Discussion started by: Shri123
1 Replies

5. Shell Programming and Scripting

UNIX script to FTP file from UNIX server to windows

Hi, I am new to this subject.....Can someone please help me out with the script... unix usernm "sdhftst" unix pwd "chsd13" windows usernm "dfghtst" windows pwd "chsd13" path..../xxx/xxxxx/xxxxxx/xxxxxxx please can u get me a script...its only one file to get ftp. Thanks... (2 Replies)
Discussion started by: himakiran9
2 Replies

6. Shell Programming and Scripting

Need to write a script to reformat a file in unix but not familiar with unix

unix script must do the fiollowing open a file containing comma delimited records > each record contains 10 fields > removes the 2nd field and use that same field containing fields 2 to 10 the original record after fprocessing should containing fields 1 and 3 a new erecord must be... (10 Replies)
Discussion started by: dwightja
10 Replies

7. UNIX for Advanced & Expert Users

Executing a shell script from windows;script present in unix

I need to execute a shell script kept in unix machine from windows. User id, password area available. For eg. There's a shell script wich moves all the logs kept in my home directory to a directory named LOGS. Now i need to get this done through windows; either using a batch file, or java... (4 Replies)
Discussion started by: rajneesh_kapoor
4 Replies

8. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

9. Shell Programming and Scripting

ftp from windows to unix using a perl script on unix machine

i need to ftp a file from windows to a unix machine by executing a sript(perl/shell/php) from that unix machine.i can also use HTML and javascript to build forms. (3 Replies)
Discussion started by: raksha.s
3 Replies

10. Shell Programming and Scripting

FTP script for sending a file from one unix directory to another unix server director

Hi, My local server is :/usr/abcd/ Remote server is :/Usr/host/test/ I want to send files from local unix directory(All files starting with O_999) to remote host unix directory. Can any body give me the Unix Shell script to do this. One more doubt: Shall we need to change the file... (1 Reply)
Discussion started by: raja_1234
1 Replies
Login or Register to Ask a Question