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
# 8  
Old 10-18-2011
Question
Getting just the entries... not getting from which file the entry is made! Smilie
# 9  
Old 10-18-2011
then modify it as below and check ..
Code:
for i in `ls file*.txt`
do
     nawk -v start="$START_TIME" '/start/ {print FILENAME}' $i >> temp-grep.txt
     awk '$0>=$from&&$0<=$to' from=$START_TIME to=$STOP_TIME $logpath/$i >> temp-grep.txt
done

# 10  
Old 10-18-2011
Thanks Jayan. However the code iterates the result in the outputfile and the file contains the whole log entry with the iterated file name. Below is the head and tail of the generated output file

Code:
> tail temp-grep.txt
 ORDER_PLAN_OID->(28884387) AUTO_RENEWED->(Y) STATUS->(PC) END_DATE->() PLAN_CODE->(120) ORDER_OID->(28879928) PLAN_GROUP->(SBP1) USAGE_ALLOWANCE->(250) START_DATE->(20111018132102) PLAN_TYPE->(D) PLAN_PRICE->(14.99) PAYMENT_METHOD->(C) SPEED_TIER_POLICY_ID->() HOT_SOC->(SBNP004)",451211265,America/Chicago,false
INSERT,p3wtg1z2.edc.cingular.net,1318942262,44,2011/10/18 07:51:02.0044 (America/Chicago),Scheduler9,1602,2089,DEBUG3,,DEBUG_LEVEL3," ""entering Br_CreateNextThresholdNotificationScheduler::"" \
        ""br_processThresholdNotification.dsd:"" ",451211265,America/Chicago,false
INSERT,p3wtg1z2.edc.cingular.net,1318942262,44,2011/10/18 07:51:02.0044 (America/Chicago),Scheduler9,1602,2090,DEBUG3,,DEBUG_LEVEL3,"Br_CreateNextThresholdNotificationScheduler::dumpmap pm_subscriber:
 USAGE_INDICATOR->(N) UPD_USR->(1) ADD_USR->(1) IMSI->(310410350798855) SUBSCRIBER_ACTVN_END_DATE->() SUBSCRIBER_PREV_STATUS->(R) IMEI->(012328002750678) SUBSCRIBER_ACTVN_STR_DATE->(20101224163948) SUBSCRIBER_STATUS_DATE->(20101224163959) UPD_USR_TMS->(20110920044924) ADD_USR_TMS->(20101224163948) BILLING_ACCOUNT_NUMBER->(346000977621) SUBSCRIBER_STATUS->(A) ACCOUNT_OID->(346000977621) PREV_SUBSCRIBER_NUMBER->() SIM->(89014104243507988554) EQUIPMENT_TYPE->(G) SERVICE_AREA->(009847003716) SUBSCRIBER_NUMBER->(9563731369) TECHNOLOGY_TYPE->(GSM) HOMING_INDICATOR->(1) SUBSCRIBER_OID->(2223596)",451211265,America/Chicago,false
INSERT,p3wtg1z2.edc.cingular.net,1318942262,44,2011/10/18 07:51:02.0044 (America/Chicago),Scheduler9,1602,2091,DEBUG3,,DEBUG_LEVEL3,"Lb_GetNextThresholdValue entering::workspace/libraries/lb_utilities.dsd:pm_currValue->30",451211265,America/Chicago,false
INSERT,p3wtg1z2.edc.cingular.net,1318942262,44,2011/10/18 07:51:02.0044 (America/Chicago),Scheduler9,1602,2092,DEBUG3,,DEBUG_LEVEL3,"Br_CreateNextThresholdNotificationScheduler::nextThreshold (absolute): ",451211265,America/Chicago,false
INSERT,p3wtg1z2.edc.cingular.net,1318942262,69,2011/10/18 07:51:02.0069 (America/Chicago),Scheduler9,1602,2093,DEBUG1,,DEBUG_LEVEL1,"Component Scheduler9: finished executing event rule ""ExpiryRule"" with no errors",,America/Chicago,false
INSERT,p3wtg1z2.edc.cingular.net,1318942274,469,2011/10/18 07:51:14.0469 (America/Chicago),Scheduler9,2576,491,DEBUG3,,DEBUG_LEVEL3,"findComponent: incrementing ref count on Scheduler9 to 238",,America/Chicago,false
INSERT,p3wtg1z2.edc.cingular.net,1318942291,569,2011/10/18 07:51:31.0569 (America/Chicago),Scheduler9,1775,5400,DEBUG3,,DEBUG_LEVEL3,"findComponent: incrementing ref count on Scheduler9 to 239",,America/Chicago,false
usprod41:/opt/app/p3wtg1z2/sbpprod1/kb521q/grep
> head temp-grep.txt
/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv

And, here is the debug level code run, let me try to work on modifying the awk for which it doesn't seem to be taking the start and end value while grepping

Code:
 bash -x jayan.sh
++ TZ=UTZ+6
++ date
+ x='Tue Oct 18 06:49:00 UTZ 2011'
++ date
+ y='Tue Oct 18 07:49:00 CDT 2011'
++ echo Tue Oct 18 06:49:00 UTZ 2011
++ awk '{print $4}'
+ START_TIME=06:49:00
++ echo Tue Oct 18 07:49:00 CDT 2011
++ cut -b12-19
+ STOP_TIME=07:49:00
++ date +%Y%m%d
+ for i in ls '/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_`date +%Y%m%d`_Scheduler*.log.csv'
+ nawk -v start=06:49:00 '/start/ {print FILENAME}' ls
nawk: can't open file ls
 source line number 1
+ awk '$0>=$from&&$0<=$to' from=06:49:00 to=07:49:00 /ls
awk: can't open /ls
+ for i in ls '/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_`date +%Y%m%d`_Scheduler*.log.csv'
+ nawk -v start=06:49:00 '/start/ {print FILENAME}' /opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
+ awk '$0>=$from&&$0<=$to' from=06:49:00 to=07:49:00 //opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler0.log.csv
+ for i in ls '/opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_`date +%Y%m%d`_Scheduler*.log.csv'
+ nawk -v start=06:49:00 '/start/ {print FILENAME}' /opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler1.log.csv
+ awk '$0>=$from&&$0<=$to' from=06:49:00 to=07:49:00 //opt/app/p3wtg1z2/sbpprod1/FW/home/UnifiedLogging/UL_20111018_Scheduler1.log.csv
//And it went on till the last file...//

Last edited by bhargav_k; 10-18-2011 at 09:57 AM..
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