02-15-2011
nawk works, however for each file create it only has the first line from the Log File in them.
NAWK OUTPUT
HTML Code:
the saved file /tmp/aabb.csv only has one line in it like below.
GCAT022
AABBC 3
the saved /tmp/plat.csv file only has one line in it like below.
DCAT024
PLATO 5
the saved file /tmp/socra.csvonly has one line in it like below.
TCAT026
SOCRA 7
Please see above for
Desired Output.
Thanks for your help again Franklin!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All ,
I have different strings (SQL queries infact) of different lengths such as:
1. "SELECT XYZ FROM ABC WHERE ABC.DEF='123' "
2. "DELETE FROM ABC WHERE ABC.DEF='567'"
3. "SELECT * FROM ABC"
I need to find out the word coming after the... (1 Reply)
Discussion started by: swapnil.nawale
1 Replies
2. Shell Programming and Scripting
Hi,
I have list of directory paths in a variable and i want to delete those dirs and if dir does not exist then search that string and get the correct path from xml file after that delete the correct directory. i tried to use grep and it prints the entire line from the search.once i get the entire... (7 Replies)
Discussion started by: dragon.1431
7 Replies
3. Shell Programming and Scripting
My source is on each line
98.194.245.255 - - "GET /disp0201.php?poc=4060&roc=1&ps=R&ooc=13&mjv=6&mov=5&rel=5&bod=155&oxi=2&omj=5&ozn=1&dav=20&cd=&daz=&drc=&mo=&sid=&lang=EN&loc=JPN HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.0.3705; .NET CLR... (5 Replies)
Discussion started by: elamurugu
5 Replies
4. Shell Programming and Scripting
Hi,
Our input xml looks like:
<doc>
<str name="account_id">1111</str>
<str name="prd_id">DHEP155EK</str>
</doc>
- <doc>
<str name="account_id">6666</str>
<str name="prd_id">394531662</str>
</doc>
- <doc>
<str name="account_id">6666</str>
<str... (1 Reply)
Discussion started by: Jassz
1 Replies
5. Shell Programming and Scripting
Hi Gurus
I am new to this forum.. I am using HP Unix OS.
I have one single string in input file as shown below
Abc123 | cde | fgh | ghik| lmno | Abc456 |one |two |three | four | Abc789 | five | Six | seven | eight | Abc098 | ........
I want to achive the result in a output file as shown... (3 Replies)
Discussion started by: kannansr621
3 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have gone through may posts and dint find exact solution for my requirement.
I have file which consists below data and same file have lot of other data.
<MAPPING DESCRIPTION ='' ISVALID ='YES' NAME='m_TASK_UPDATE' OBJECTVERSION ='1'>
<MAPPING DESCRIPTION ='' ISVALID ='NO'... (11 Replies)
Discussion started by: tmalik79
11 Replies
7. Shell Programming and Scripting
Input file:
#read_1
AWEAWQQRZZZQWQQWZ
#read_2
ZZAQWRQTWQQQWADSADZZZ
#read_3
POGZZZZZZADWRR
.
.
Desired output file:
#read_1 3
#read_1 1
#read_2 2
#read_2 3
#read_3 6
.
. (3 Replies)
Discussion started by: perl_beginner
3 Replies
8. Shell Programming and Scripting
Hello friends, I need a BIG help from UNIX collective intelligence:
I have a CSV file like this:
VALUE,TIMESTAMP,TEXT
1,Sun May 05 16:13:05 +0000 2013,"RT @gracecheree: Praying God sends me a really great man one day. Gotta trust in his timing.
0,Sun May 05 16:13:05 +0000 2013,@sendi__... (19 Replies)
Discussion started by: kraterions
19 Replies
9. Shell Programming and Scripting
Hi,
I have a sample file as shown below, I am looking for sed or any command which prints the complete word only from the input file.
Ex:
$ cat "sample.log"
I am searching for a word which is present in this file
We can do a pattern search using grep but I need to cut only the word which... (1 Reply)
Discussion started by: mohan_kumarcs
1 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
I'm writing unix shell script and I have these files. I need to get name before _DETL.tmp.
ABC_AAA_DETL.tmp
ABC_BBB_DETL.tmp
ABC_CCC_DETL.tmp
PQR_DETL.tmp
DEF_DETL.tmp
JKL_DETL.tmp
YUI_DETL.tmp
TG_NM_DDD_DETL.tmp
TG_NM_EEE_DETL.tmp
GHJ_DETL.tmp
RTY_DETL.tmp
output will... (3 Replies)
Discussion started by: ace_friends22
3 Replies
MONGO(1) Mongo Database MONGO(1)
NAME
mongo - the Mongo command-line tool
SYNOPSIS
mongo [OPTIONS] [DB_ADDRESS] [FILE+]
DESCRIPTION
mongo is a JavaScript shell (with GNU readline capabilities). It supports interactive and non-interactive use. When used interactively,
JavaScript can be used to query the database or perform any other function normally available with SpiderMonkey. Database output is dis-
played in JSON format.
If JavaScript files are specified on the command line, the shell will run non-interactively, running each one in sequence and then exiting.
EXAMPLES
mongo start the shell, connecting to the server at localhost:27017 and using the test database
mongo foo
start the shell using the foo database at localhost:27017
mongo 192.169.0.5/foo
start the shell using the foo database at 192.169.0.5:27017
mongo 192.169.0.5:9999/foo
start the shell using the foo database at 192.169.0.5:9999
mongo script1.js script2.js script3.js
run three scripts and exit
OPTIONS
--shell
run the shell after executing files
--help show usage information
--host HOST
server to connect to (default HOST=localhost)
--port PORT
port to connect to (default PORT=27017)
--nodb do not connect to mongod
--eval SCRIPT
evaluate JavaScript
-u USERNAME
specify user to log in as
-pPASSWORD
specify password of user (notice there is no space)
COPYRIGHT
Copyright 2007-2009 10gen
SEE ALSO
For more information, please refer to the MongoDB wiki, available at http://www.mongodb.org.
AUTHOR
Kristina Chodorow
10gen June 2009 MONGO(1)