'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
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)
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)
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)
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,
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)
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,
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 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)
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)