i'am trying to write a shell program which takes a data element
from one file(var/tmp/usr1/pools)and search that data element
in a zipped file in archive location/usr01/archive/PSta*.Z).
below program writes that zipped filename into a temp file(/var/tmp/usr1/fcount) if it finds the occurence.
lets consider that the data element found two files having it's occurence and wrote
two filenames to the temp file, Now my goal is to find the latest filename having that
occurence(data element).
the program is getting all the file names into /var/tmp/usr1/fcount where i 'am not able to get the latest
file for each data element
i've been trying without any success..will appreciate if any one help me out here.
thanks
kmr023
'for j in *' has the same size limit as the backticks problem. If you have more than a dozen or two files, or the number of files continually grows, this may eventually become a problem.
I don't quite understand the purpose of for j in `ls ${fl}/*.Z | tr -s ' '| cut -d" " -f9 | cut -d\/ -f7`. Are you rewriting your own basename? I don't see any purpose for basename here either.
I don't think grep "PSta*" does what you think it does. grep uses regular expressions, not shell globs, so "a*" here means "zero or more 'a' characters". So it'd match any line containing PSt at all. Just the expression 'PSta' should suffice if you want to find any line with those four letters.
You don't need to pipe grep into wc -l to measure whether grep found any results. grep's return code tells you whether it found anything, which you can feed directly into an ordinary if statement:
grep can do nearly your entire program by itself, using -f and -F to tell it to read patterns from files instead of the commandline.
My version: ---------- Post updated at 09:56 AM ---------- Previous update was at 09:52 AM ----------
You could dispense with the temp file completely actually.
Last edited by Corona688; 09-14-2011 at 01:02 PM..
Reason: fixed paths
I have this 5GB file, and i want to extract from the file particulars pattern.
this is my script:
//
count=`grep -wc "MSISDN" file_name`
k=1
>OUTPUT
>OUTPUT_Final
while
do
cat file_name | awk -F":" -v var="$k" '$1=="MSISDN" {m++}m==var{print; exit}' >> OUTPUT
cat file_name |awk -F":"... (33 Replies)
Hi everyone,
I have a csv file which has data with different heading and column names as below.
Static Data Ingested
,,,,,,,,,,,,Known Explained Rejections
Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
hi,
i'am trying to write a script which takes a data element from one file and searches in a certain file path and after it finds it it redirects the file names to a new file...Now i have to pick the up the last modified file's Timestamp(MMDDYY) from the files collected for each data element.
... (2 Replies)
Hi
Not to good with data extraction . I have some output that looks like this
1301925447 1 2 2 mtlhqmst 16215531 0 0 *NULL* bpduplicate Initiating optimized duplication from @aaagc to @aaaeG
1301925484 1 2 4 snccprd6 16215531 0 0 hwd-rg-f04b bpdm begin copying backup id... (5 Replies)
Hi,
Pleae find the attached files. I want to extract all the table names that has got * mark within its last column data. The doc file will give you a clear picture of what I am trying to do. Tables names in oval should be extracted in other file because it has got * mark in its last column data (5 Replies)
If I have a log like :
Mon Jul 19 05:07:34 2010; TCP; eth3; 52 bytes; from abc to def
Mon Jul 19 05:07:35 2010; UDP; eth3; 46 bytes; from aaa to bbb
Mon Jul 19 05:07:35 2010; TCP; eth3; 52 bytes; from def to ghi
I will need an output like this :
Time abc to def... (1 Reply)
Hi All, Prepare a perl script for extracting data from xml file. The xml data look like as
AC StartTime="1227858839" ID="88" ETime="1227858837" DSTFlag="false" Type="2" Duration="303" />
<AS StartTime="1227858849" SigPairs="119 40 98 15 100 32 128 18 131 23 70 39 123 20 120 27 100 17 136 12... (3 Replies)
Hi,
This is the xml file that i have.
- <front-servlet platform="WAS4.0" request-retriever="SiteMinder-aware" configuration-rescan-interval="60000">
<concurrency-throttle maximum-concurrency="50" redirect-page="/jsp/defaulterror.jsp" />
- <loggers>
<instrumentation... (5 Replies)
Hello All,
I am starting with UNIX. Any help is highly appreciated.
How to extract data using UNIX shell script? And how do you export data using UNIX shell scripts into Microsoft Excel format?
Thank you. (3 Replies)