04-22-2013
Quote:
Originally Posted by
rrb2009
Hi,
Thanks for the replies. I will be more specific.
[..]
Thanks and let me know if I need to give an other specifics.
What did not work? What is your OS and version?
Also, what field separator do your CSV's use?
This User Gave Thanks to Scrutinizer For This Post:
9 More Discussions You Might Find Interesting
1. SCO
I am installing the my package in SCO unix 5.0 .so it will create some temporary directories and files and same will delete.So , 'rm -R ' is not working in system .in the package only it has given this command,so now without this command working we can not go forward.
so kindly help in this... (1 Reply)
Discussion started by: mokri_1980
1 Replies
2. Shell Programming and Scripting
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies
3. Shell Programming and Scripting
Hi
I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this?
Thanks
Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies
4. Shell Programming and Scripting
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies
5. Shell Programming and Scripting
Hello;
I need to generate a csv file that contains a list of all the files in a particular server (from the root directory ie: \) that have a permission stamp of 777. I would like to create the csv so that it contains the following:
server name, file name, full path name where file exists,... (17 Replies)
Discussion started by: gvolpini
17 Replies
6. UNIX for Dummies Questions & Answers
Hello All,
I have a .csv file named as remark.csv
The csv file content looks like below:
Remark_Hello_1 Remark_Hello_2 Remark_Hello_3 Remark_Hello_4
Hello_World_FW_0001 X
Hello_World_FW_0002 X X
Hello_World_FW_0003 X X
Hello_World_FW_0004 X X
I... (5 Replies)
Discussion started by: suvendu4urs
5 Replies
7. Shell Programming and Scripting
hello...
i have a requirement to convert a xls file to csv in RHEL 6.5 and ftp it to a windows location.
i am using xls2csv utility to convert the file in linux.
Input xls file attached...
I have used below commands to convert the file to csv:
xls2csv -x test.xls -s cp1252 -d 8859-1... (3 Replies)
Discussion started by: rhel65
3 Replies
8. Shell Programming and Scripting
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)
Discussion started by: refrain
8 Replies
9. Shell Programming and Scripting
Hi,
I have another problem. I want to sort another csv file by the first field.
result.csv
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw
/home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 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)