@malcomex999/Jean
Thank You both for the help . The logic is working fine and i have been able to do what i wanted.
Code:
awk -F, '$7 && !dup[$2,$3,$4,$8]++' infile
But I would like to understand the logic behind -F operation. How does the deletion happen here? What is the logic behind choosing the row to be deleted?
Can i use more than one field to decide the line to be deleted.If yes, how?
@ygemici
Thnx for the code. I have not been able to implement the logic till now. Will surely get back to you after using it.
Cheers,
Sheel
Last edited by Scott; 05-05-2010 at 01:27 PM..
Reason: Code tags
Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Hello,
I have this file that sometime contains 0 lines and sometimes 1 or more.
It's supposed to then put the result (could be 0 or 1 or 2 or more) into a variable.
Then it's supposed to echo using an if else statement depending on the value of the variable.
flagvar='wc -l $tempfile |... (1 Reply)
Hello All,
i am a newbie and need some help when reading a csv file in a bourne shell script. I want to read 10 lines, then wait for a minute and then do a reading of another 10 lines and so on in the same way. I want to do this till the end of file.
Any inputs are appreciated
... (3 Replies)
I have a file which has following content:
NAME=ora.DG1.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE
NAME=ora.DG2.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE
NAME=ora.DG3.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE
NAME=ora.DG4.dg... (7 Replies)
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
I have a file lets say input.csv having two columns like-
Name,Mobile No
A,111
B,222
A,333
A,123
B,213
I would like to find result in a new file lets say output.csv as-
Name,Mobile No
A,111
B,222
means short the file on the basis of first column and first value corresponding to the... (5 Replies)
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
1.csv contains following column-
Empid code loc port
101 A xy 01
102 B zx 78
103 A cg 12
104 G xy 78
2.csv contains follwing data-
Empid code loc port
101 A gf 01
102 B zx 78
103 C cg 32
104 ... (1 Reply)
Hi..
I need some help in converting the below horizontal lines to vertical lines format.
can anyone help me on this.
input file
Hour,1,2,3,4,5
90RT,106,111,111,112,111
output file
Hour,90RT
1,106
2,111
3,111
4,112
5,111 (3 Replies)
Discussion started by: Raghuram717
3 Replies
LEARN ABOUT DEBIAN
mongoexport
MONGOEXPORT(1) Mongo Database MONGOEXPORT(1)NAME
mongoexport - the Mongo export tool
SYNOPSIS
mongoexport [OPTIONS]
DESCRIPTION
mongoexport is a tool to export a MongoDB collection to either JSON or CSV. The query can be filtered or a list of fields to output can be
given.
If the output is CSV, the fields must be specified in order.
EXAMPLES
mongoexport -d test -c test1 --csv -f name,num
export documents from test.test1 in CSV format
OPTIONS --help show usage information
-h, --host HOST
server to connect to (default HOST=localhost)
-d, --db DATABASE
database to use
-c, --c COLLECTION
collection to use
-q, --query QUERY
query filter
-f, --fields FIELDS
comma-separated list of field names
--csv export to CSV instead of JSON
-o, --out FILE
output file, if not specified, stdout is used
--dbpath PATH
directly access mongod data files in this path, instead of connecting to a mongod instance
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 MONGOEXPORT(1)
05-05-2010
Read Two lines in a CSV File and Compare
