Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

File name from a List of files

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File name from a List of files
# 1  
Old 10-13-2011
MySQL File name from a List of files
Hi,

Greetings!!

I'm grepping a string from a series of files, using the below code (how ever the awk is not grepping between 'from' & 'to' time!)

Code:
awk '$0>=$from&&$0<=$to' from=$START_TIME to=$STOP_TIME $logpath/UL_`date +%Y%m%d`_Scheduler*.log.csv > temp-grep.txt

Out of 50 files, wherever the string had occured, It'll redirect it to a temp file.

My query here is, how can I find, from which file the entry is made to the temp file?

Please help me.

Thank you in advance...

<<A Correction in the query!!! Posted at 4th reply... Sorry!!!>>
Last edited by bhargav_k; 10-13-2011 at 07:07 AM..
# 2  
Old 10-13-2011
Code:
$ for i in $(find /your/path/to/50files -type f -print); do echo "$i"; awk '/start/,/end/' $i >> tempfile; done

This User Gave Thanks to jayan_jay For This Post:
bhargav_k
# 3  
Old 10-13-2011
Thanks Jayan.

This was useful, However this does the same function as the one that I'm using now (Code in Initial post).

What I was expecting is like below

/opt/app/bharg

file1.txt
file2.txt
file3.txt

Now, I'm redirecting logs that are generated for an hour from /opt/app/bharg/file*.txt and redirect it to a temp file.

Code:
awk '$0>=$from&&$0<=$to' from=$START_TIME to=$STOP_TIME $logpath/file*.txt > temp-grep.txt

cat temp-grep.txt | grep 'ORA' > error_found.txt

Now, I'm grepping the temp file for a string, If string found, it'll redirect it to error_found file.

Till now this is working, my query is; How do I find from which of the file*.txt , the string got redirected to error_found file.
# 4  
Old 10-13-2011
can you post the contents of temp-grep.txt
# 5  
Old 10-13-2011
Code:
Validating address (getting geocode) of subscriber in OTSM... ",56241257,America/Chicago,false
INSERT,p3wtg1z2.edc.cingular.net,1318483203,131,2011/10/13 00:20:03.0131 (America/Chicago),Scheduler0,1620,257019,DEBUG2,,DEB
UG_LEVEL2,"Lb_OTSMCreateUserPasswordHeader::UserPasswordHeaderAVS->AVS::OTSM_UserPasswordHeader
UserName(STRING) -> m70991
Password(STRING) -> ykGus2jG
",56241257,America/Chicago,false
INSERT,p3wtg1z2.edc.cingular.net,1318483203,131,2011/10/13 00:20:03.0131 (America/Chicago),Scheduler0,1620,257020,DEBUG1,,DEB
UG_LEVEL1,"Lb_OTSMSendValidateAddressRequest::
Auto Renew Purchase scheduler started with entityId... 26359230_3",578918291,America/Chicago,false
INSERT,p3wtg1z2.edc.cingular.net,1318485495,26,2011/10/13 00:58:15.0026 (America/Chicago),Scheduler0,1620,257374,DEBUG1,,DEBU
G_LEVEL1,"Lb_CPMGetOrderPlan::Getting order plan (26359230)",,America/Chicago,false

When I grep INSERT, the above will be redirected from multiple log files under a directory.

But, out of 50 files, I'm confused from which all files, this entry is made to the temp file.

---------- Post updated at 05:06 AM ---------- Previous update was at 04:40 AM ----------

I realize that I was trying to get the file name after It is being redirected.

1. Redirect the log between start and end time to a temp file
2. Grep the temp file for string and redirect to error file

I was trying to get the file name from where the string is captured at step 2. Where in it should be captured at step 1 itself.
# 6  
Old 10-13-2011
You have got it .. try modify your awk code accordingly ..
# 7  
Old 10-14-2011
CPU & Memory
Ok, Let me try to modify and post the result...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

List dublicated files into a file

Dear All, I have many files in a directory similar in below format (in order to understand each group files are separated from others by blank lines ). I want to find duplicate filenames and write them into a new file line by line. I tried several scripts but I couldn't be successful. Do... (9 Replies)
Discussion started by: bulpak
9 Replies

2. Shell Programming and Scripting

While loop a file containing list of file names until the files are found?

Hi, I have a control file which will contain all filenames(300) files. Loop through all the file names in the control files and check the existence of this file in another directory(same server). I need to infinitely(2 hrs) run this while loop until all the files are found. Once a file is found,... (5 Replies)
Discussion started by: laknar
5 Replies

3. Shell Programming and Scripting

How to list files that are not first two files date & last file date for every month-year?

Hi All, I need to find all files other than first two files dates & last file date for month and month/year wise list. lets say there are following files in directory Mar 19 2012 c.txt Mar 19 2012 cc.txt Mar 21 2012 d.txt Mar 22 2012 f.txt Mar 24 2012 h.txt Mar 25 2012 w.txt Feb 12... (2 Replies)
Discussion started by: Makarand Dodmis
2 Replies

4. Shell Programming and Scripting

File that Contains a List of Files

I have a first text file (LoopFiles.txt) that contains another list of text files. I need to run NAWK commands on each of the files that are listed in the first text file. I have proven the existence of the first file with ls -l But I get a message that my first file doesnt exist. cd... (5 Replies)
Discussion started by: he204035
5 Replies

5. Shell Programming and Scripting

Take a list if strings from a file and search them in a list of files and report them

I have a file 1.txt with the below contents. -----cat 1.txt----- 1234 5678 1256 1234 1247 ------------------- I have 3 more files in a folder -----ls -lrt------- A1.txt A2.txt A3.txt ------------------- The contents of those three files are similar format with different data values... (8 Replies)
Discussion started by: realspirituals
8 Replies

6. Shell Programming and Scripting

Delete old files but with exclusion with file list

Hello Can you please help and check what im missing on script below the goal is to delete the old files more than 7 days old but not the excluded file list inside excluded.dat file #!/bin/sh EXCLUDE=/path/to/exclude/exclude.dat FIND=/bin/find for xfile in '(read $EXCLUDE)' do $FIND... (9 Replies)
Discussion started by: angst_nu
9 Replies

7. Shell Programming and Scripting

List the file or files with last modification date

hi. I need help my programing friends :p I need to list all the files with a certain name (for example FileName) by last modification date but only the one with the last date. If there are two files with the same name and same modification date it should print the both. For example in this set... (6 Replies)
Discussion started by: KitFisto
6 Replies

8. Shell Programming and Scripting

ls > file - Creating file containing the list of all files present in a directory

Hi All, I need to create a file which contains the list of all the files present in that directory. e.g., ls /export/home/user/*.dat > list_file.dat but what i am getting is: $ ls /export/home/user/*.dat > list_file.dat /export/home/user/*.dat: No such file or directory But I have... (1 Reply)
Discussion started by: pranavagarwal
1 Replies

9. UNIX for Dummies Questions & Answers

how to list the files using File Descriptors

hello, I have written a script named listall.sh with the following codes init. #!/bin/bash PATH="/proj/cmon/$1" echo $PATH if ; then echo "Usage: $0 ***" exit 1 else ls -l $PATH/*.sc fi Here there are 3 subdirectories (namely - src, data and jobs)under /proj/cmon, so... (2 Replies)
Discussion started by: shyjuezy
2 Replies

10. UNIX for Dummies Questions & Answers

filesize from a file which has the list of files.

i have a file myfile. it has the below entries /temp/firstfile /temp/secondfile and many more.. okay, now, i want to addup all the space occupied by this file hmmm, but i met with a problem in getting each file out. i did a silly command like more myfile | grep temp | ls -ltr and it... (3 Replies)
Discussion started by: yls177
3 Replies
Login or Register to Ask a Question