Reading 2 CSV files and filtering data based on group Post: 302710255

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to listout the files based on group by the date...?

Hi, How to listout the files based on group by of date...? suppose if have list of 10 files which was created by on today(Apr 18) and yesterday(Apr 17 ) in my personal directory like this if i issue ls -rtl | grep "Apr 18" list out the file which was created/updated only on Apr 18th. ...

2. Shell Programming and Scripting

Help with pulling / filtering data from a .csv

Good day Gurus, I have a csv file that contains an inventory of active servers. This csv file contains a well over a hundred systems (IBM, SUN, HP). It also contains those systems details. See below for an example hostA,invver,1.02,20100430 hostA,date,08/30/2010,06:18 hostA,use,"Unknown...

3. Shell Programming and Scripting

Reading the data from CSV and performing search through shell script

Hello, I am working on building a script that does the below actions together in my Linux server. 1) First, have to read the list of strings mentioned in CSV and store it in the shell script 2) Second, pick one by one from the string list, and search a particular folder for files that...

4. Shell Programming and Scripting

extract data in a csv file based on a certain field.

I have a csv file that I need to extract some data from depending on another field after reading info from another text file. The text file would say have 592560 in it. The csv file may have some data like so Field 1 Field2 Field3 Field4 Field5 Field6 20009756 1 ...

5. Shell Programming and Scripting

Matching and Merging csv data fields based on a common field

Dear List, I have a file of csv data which has a different line per compliance check per host. I do not want any omissions from this csv data file which looks like this: date,hostname,status,color,check 02-03-2012,COMP1,FAIL,Yellow,auth_pass_change...

6. UNIX for Dummies Questions & Answers

using sed delete a line from csv file based on specific data in two separate fields

Hello, :wall: I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books. I know this does not work /^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d Any ideas? Thanks Please...

7. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file based on certain conditions

Hi Guys, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm....

8. Shell Programming and Scripting

Script for extracting data from csv file based on column values.

Hi all, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm....

9. Shell Programming and Scripting

Filtering data from text to csv

Hello, Is there a way to filerter data from a text file as shown below to a Column e.g. hostname nfsmount as two separate column. Currently I could get hostname and the mount is appearing below.. using this script #! /bin/bash for i in `cat fqdn.txt` do echo "$i ............ " >>...

10. UNIX for Beginners Questions & Answers

Filtering records of a csv file based on a value of a column

Hi, I tried filtering the records in a csv file using "awk" command listed below. awk -F"~" '$4 ~ /Active/{print }' inputfile > outputfile The output always has all the entries. The same command worked for different users from one of the forum links. content of file I was...

LEARN ABOUT DEBIAN

image::exiftool::import

Image::ExifTool::Import(3pm)				User Contributed Perl Documentation			      Image::ExifTool::Import(3pm)

NAME

       Image::ExifTool::Import - Import CSV and JSON database files

SYNOPSIS

	   use Image::ExifTool::Import qw(ReadCSV ReadJSON);

	   $err = ReadCSV($csvFile, \%database);

	   $err = ReadJSON($jsonfile, \%database);

DESCRIPTION

       This module contains routines for importing tag information from CSV (Comma Separated Value) and JSON (JavaScript Object Notation) database
       files.

EXPORTS

       Exports nothing by default, but ReadCSV and ReadJSON may be exported.

METHODS

   ReadCSV / ReadJSON
       Read CSV or JSON file into a database hash.

       Inputs:
	   0) CSV file name.

	   1) Hash reference for database object.

	   2) Optional flag to set '-' values to undef in the database.  (Used for deleting tags.)

	   3) [ReadJSON only] Optional character set for converting Unicode escape sequences in strings.  Defaults to "UTF8".  See the ExifTool
	   Charset option for a list of valid settings.

       Return Value:
	   These functions return an error string, or undef on success and populate the database hash with entries from the CSV or JSON file.
	   Entries are keyed based on the SourceFile column of the CSV or JSON information, and are stored as hash lookups of tag name/value for
	   each SourceFile.

AUTHOR

       Copyright 2003-2011, Phil Harvey (phil at owl.phy.queensu.ca)

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Image::ExifTool(3pm)

perl v5.12.4							    2011-03-12					      Image::ExifTool::Import(3pm)