Need Unix Shell Script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need Unix Shell Script
# 1  
Old 02-08-2009
Bug Need Unix Shell Script

Hi Guys,
I am new to Unix, I need shell script in Unix as follows
I have 3 files with .OUT as extensions, I need a script to read these 3 files and match the character positions from 28-35 with the string 20090203, if it matches with this pattern in any record, take that record and write it to a new file.
# 2  
Old 02-08-2009
You can use awk for that:
Code:
awk 'substr($0,28,8)==date {print > output}' date=20090203 output=output.file *.OUT

# 3  
Old 02-08-2009
Please guide me, if i am doing any mistake...

Hi,
Thanks for your quick response,
I have tried the command given below, but i am not getting any output after execution, i.e., it is not creating any outputfile after executing this command, and for your reference i am using ubuntu 6.0 version in my laptop and executing this command at the shell prompt, please suggest me, if i am doing anything wrong......
# 4  
Old 02-08-2009
You should post a data sample data (use [code] tags) or reconsider your problem.
# 5  
Old 02-09-2009
Try this out..
This code will take all files with '.out' as extension and search for the string in those file and finally print the desired lines into a new file.

ls *.out | while read name
do
awk '{ print substr ($0, 6 , 15 ); }' $name | grep 20090203 >> new
done
# 6  
Old 02-09-2009
It is just displaying the given search pattern

It is just displaying the given search pattern, i.e., once the given script is executed it is just storing 20090203 in the output file, but it is not our requirement
# 7  
Old 02-09-2009
Code:
awk -v date=20090203 'substr($0,28,8)==date' *.OUT  > output.file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

Batch script to execute shell script in UNIX server

Hi team, My requirement is to transfer pdf files from windows machine to unix server and then from that unix server we should sftp to another server. I have completed the first part i.e From windows to using to unix server with the help of psftp.exe code: psftp user@host -pw password <... (1 Reply)
Discussion started by: bhupeshchavan
1 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

Dos batch script to execute unix shell script

Can anyone help me with a dos batch script to execute a shell script residing in an unix server. I am not able to use ssh. Thanks in advance (2 Replies)
Discussion started by: Shri123
2 Replies

5. 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

6. 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

7. Shell Programming and Scripting

help me in sending parameters from sqlplus script to unix shell script

Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files.. Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this? Please tell me... (2 Replies)
Discussion started by: Hara
2 Replies

8. Shell Programming and Scripting

check in unix shell script so that no one is able to run the script manually

I want to create an automated script which is called by another maually executed script. The condition is that the no one should be able to manually execute the automated script. The automated script can be on the same machine or it can be on a remote machine. Can any one suggest a check in the... (1 Reply)
Discussion started by: adi_bang76
1 Replies

9. AIX

Difference between writing Unix Shell script and AIX Shell Scripts

Hi, Please give me the detailed Differences between writing Unix Shell script and AIX Shell Scripts. Thanks in advance..... (0 Replies)
Discussion started by: haroonec
0 Replies

10. Shell Programming and Scripting

How to run unix commands in a new shell inside a shell script?

Hi , I am having one situation in which I need to run some simple unix commands after doing "chroot" command in a shell script. Which in turn creates a new shell. So scenario is that - I need to have one shell script which is ran as a part of crontab - in this shell script I need to do a... (2 Replies)
Discussion started by: hkapil
2 Replies
Login or Register to Ask a Question