12-07-2011
thanks @balajesuri m looking something like dat. i dnt knw much scripting ..but perl i have never used. here m trying to clear my scenario..hope you will understand.
Scenario:
Suppose many *.csv files are in a directory.
Script has to go through all the csv files n check if all the field contains some value. i.e., they are not NULL. like two commas are not coming together. i.e., ",," or ", ,".
then script print the corresponding names on screen which csv files having empty field.
its a bit difficult task for a newbie like me.
thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi there, been pondering how to deal with this and hoping someone would give me an insight on this.
I need help on creating a reusable bash funtion to parse csv files containing different number of fields (comma-seperated).
My initial thought is to create function for each input csv file (20+... (2 Replies)
Discussion started by: jy2k7ca
2 Replies
2. Shell Programming and Scripting
Hi all,
I have one CSV file(MasterFile.csv) consists of two columns.
"./incoming/ABC.CSV","./incoming/ABC_CONTROL.txt"
"./incoming/PQR.CSV","./incoming/PQR_CONTROL.txt"
"./incoming/123.CSV","./incoming/123_CONTROL.txt"
I have written a script to read the MasterFile.csv.Here i want to... (4 Replies)
Discussion started by: sollins
4 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I am working right now with a csv file and I want to insert an excel formula say to the 6th column.
sample csv file:
1234,lag,0,77,544,,7
1234,lag,222,0,7,,7
at first i used a simple command:
sed 's/^\(.\{17\}\)/\1word/' file.csv
but the result is this:
... (2 Replies)
Discussion started by: paoie
2 Replies
4. Web Development
Hi,
I am sharing this tip with you all.The codes given below will explain
/**
* Checking a folder is empty or not.
* @param string $folderName
* $folderName should be folder name or path
* @return TRUE/FALSE (If any file or folder found/Empty folder)
*/
function... (1 Reply)
Discussion started by: elizas
1 Replies
5. Shell Programming and Scripting
SHELL SCRIPT
Hi,
I have 3 separate files within a folder. Every File contains data in a single column like
File1 contains data
mayank
sushant
dheeraj
File2 contains
DSA_AT
MG_AT
FLAT_09
File3 contains data
123123
232323 (2 Replies)
Discussion started by: mayanksargoch
2 Replies
6. Shell Programming and Scripting
Is there some easy way to trim empty fields but only in a given range?
for example say I have csv data that looks like this:
apple,,,Granysmith,,2.50,,TimmysGrocers
Pear,Bartlett,,,,,Park,
peach,,,,Peento,3.00,Garden,TimmysGrocers
is there a way of getting the single field with data... (4 Replies)
Discussion started by: cue
4 Replies
7. Programming
I have a string s
Are the following equivalent?
if ( ! s.empty() ) {
}
if ( s ) {
} (1 Reply)
Discussion started by: kristinu
1 Replies
8. Shell Programming and Scripting
Hello,
For our work we use several scripts to gather/combine data for use in our webshop. Untill now we did not had any problems but since a couple days we noticed some mismatches between imports.
It happened that several barcodes where matched even though it was a complete other product. Of... (19 Replies)
Discussion started by: SDohmen
19 Replies
9. Shell Programming and Scripting
Hello
I have a file like this
a,b,c,1,2,3,d,e,f,,,,g,h,i,,,,j,k,l
and using awk 'FS="'"{print $9,$10,$11}' does not work as I was hoping. I would like the empty fieds, i.e. between the two comma to be interpreted as a zero. is this possible?
I would like to get f 0 0 out of the above... (1 Reply)
Discussion started by: garethsays
1 Replies
10. Shell Programming and Scripting
I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file
Command that Ive been using... (6 Replies)
Discussion started by: dis0wned
6 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)