02-17-2009
Okay - it would help if you posted desired output - plus your csv file example is not a csv format - no commas foir example - we cannot tell "fields" apart.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I was trying to grep a variable with one space in my file:
questionlabel=Q1
more job.tex
Q1 pear
Q1A applie
grep -i "$questionlabel\ " job.tex > tmp
But I keep getting :
Q1 and Q1A both in my tmp
Thanks!!!! (4 Replies)
Discussion started by: whatisthis
4 Replies
2. Shell Programming and Scripting
Hi Can any one help me remove the unwanted data? I would want to remove the complete event id 4910 ( the type there is INFO), that means, I have to remove starting from 7th - 19th lines. can any one of you please help?
Thanks, (24 Replies)
Discussion started by: hitmansilentass
24 Replies
3. Shell Programming and Scripting
Hi
I would like to replace one of our script, and add some pre-checking for the input file before running the command, but I bumped into the following issue:
Original command: use < input.txt
I cannot modify the original command, but I created the useit script which would be called as... (2 Replies)
Discussion started by: apapp
2 Replies
4. Shell Programming and Scripting
Hello Experts:
I appeal to you to see if you can help me with a small problem. I have a .log file where there is data in two columns (separated by a space).
The file is thus:
0.0 3
0.0 6
0.0 6
0.0 6
0.0 7
0.0 7
0.0 7
0.0 7
0.0 11
0.0 11
0.0 11
0.0 11
0.0 11
0.1 17 (6 Replies)
Discussion started by: Flamex
6 Replies
5. Shell Programming and Scripting
Could any one help me to compare the date value say at 10th column with sysdate (i.e current date) and if diffrence is more than 50 days then filter them out from the file. The file contain 10000 records.
head file
00971502657744 A671FAHP2EW8BG1369172011HRWS contact information ... (6 Replies)
Discussion started by: zooby
6 Replies
6. Shell Programming and Scripting
Hi,
I am trying to create a text file from data retrieved from a query.The data retrieved is having this character '^L' at regular intervals of the data.
How can i eliminate this, Please find below the sample data.
I tried sed -e "s/\^L//g" to convert it, but with no luck
^LCODE*SERIAL... (11 Replies)
Discussion started by: ramkiran77
11 Replies
7. Shell Programming and Scripting
Experts ,
Below is the data:
--- Physical volumes ---
PV Name /dev/dsk/c1t2d0
VG Name /dev/vg00
PV Status available
Allocatable yes
VGDA 2
Cur LV 8
PE Size (Mbytes) 8
Total PE 4350
Free PE 2036
Allocated PE 2314
Stale PE 0
IO Timeout (Seconds) default
--- Physical volumes ---... (5 Replies)
Discussion started by: rveri
5 Replies
8. UNIX for Dummies Questions & Answers
hi
i have my input data like this
aaa bbb ccc
asa dff nmj
mnj saa dff
oik
aax cdx saa
oik
asq sdf dssi want my output file to be like this
mnj saa dff oik
aax cdx saa oiki want to retain only those lines which will have oik just below them and i want oik to be as next column to those... (1 Reply)
Discussion started by: anurupa777
1 Replies
9. Shell Programming and Scripting
Hi All,
Please help me how to remove the records from the file if it is having more number of fields than the required one, before loading into stage
Here is the sample records. File is space delimited one
chandu 1121324 CC ( 2 spaces)
chandu balu 434657 DD (3 spaces) -- failing due to... (10 Replies)
Discussion started by: bbc17484
10 Replies
10. Shell Programming and Scripting
I have data file that has this in it:
data.txt
.........
.........
PPJ97**2017PPJ97**2017-03-21-13.35.15.887208********************START ERROR LOGGING******************
PPJ97**2017-03-21-13.35.15.887208** PROMPT APPLICATION ERROR **
PPJ97**2017-03-21-13.35.15.887208** IN TIMESTAMP |... (1 Reply)
Discussion started by: SkySmart
1 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)