checking csv files with empty fields..! Post: 302579892

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Re-usable function to parse csv files with different number of fields

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. Shell Programming and Scripting

Checking the Empty line in csv file

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...

3. UNIX for Dummies Questions & Answers

Fields in csv files using sed

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: ...

4. Web Development

Checking if a folder is empty or not using PHP

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...

5. Shell Programming and Scripting

How to create a CSV File by reading fields from separate files

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

6. Shell Programming and Scripting

Trim empty fields in a given range

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...

7. Programming

Checking not empty string

I have a string s Are the following equivalent? if ( ! s.empty() ) { } if ( s ) { }

8. Shell Programming and Scripting

CSV joining and checking multiple files

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...

9. Shell Programming and Scripting

awk empty fields

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...

10. Shell Programming and Scripting

Matching two fields in two csv files, create new file and append match

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...

LEARN ABOUT DEBIAN

mongoimport

MONGOIMPORT(1)							  Mongo Database						    MONGOIMPORT(1)

NAME

       mongoimport - the Mongo import tool

SYNOPSIS

       mongoimport [OPTIONS]

DESCRIPTION

       mongoimport  is a tool to import a MongoDB collection from JSON, CSV, or TSV. The query can be filtered or a list of fields to input can be
       given.

   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 (some commands)

       --dbpath PATH
	      directly access mongod data files in this path, instead of connecting to a mongod instance

       -v, --verbose
	      be more verbose (include multiple times for more verbosity e.g. -vvvvv)

       -f, --fields NAMES
	      comma separated list of field names e.g. -f name,age

       --fieldFile FILE
	      file with fields names - 1 per line

       --jsonArray
	      load a json array, not one item per line. Currently limited to 4MB.

       --ignoreBlanks
	      if given, empty fields in csv and tsv will be ignored

       --type TYPE
	      type of file to import.  default: json (json,csv,tsv)

       --file FILE
	      file to import from; if not specified stdin is used

       --drop drop collection first

       --headerline
	      CSV,TSV only - use first line as headers

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								   January 2010 						    MONGOIMPORT(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Re-usable function to parse csv files with different number of fields

Discussion started by: jy2k7ca

2. Shell Programming and Scripting

Checking the Empty line in csv file

Discussion started by: sollins

3. UNIX for Dummies Questions & Answers

Fields in csv files using sed

Discussion started by: paoie

4. Web Development

Checking if a folder is empty or not using PHP

Discussion started by: elizas