07-15-2012
Quote:
I have File A as CSV Format
(Added Code Tags to Post #1).
The input file is clearly not CSV (Comma Separated Value) because there are no commas. As @agama notes, please state whether the field separator is tab(s) or space characters or a mixture of both characters.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
2. UNIX for Dummies Questions & Answers
I have a file with follwing content
----------------------------------
SCHEDULE XXXXXXXXX#JOBCOUNT
ON EVERYDAY
AT 0000
PRIORITY 50
SCHEDULE XXXXXXXXX#ABCDEFGH
ON EVERYDAY
AT 0001
PRIORITY 29
SCHEDULE... (5 Replies)
Discussion started by: shreyas
5 Replies
3. UNIX for Dummies Questions & Answers
Hi,
Using rsync, I've sent the output to a text file. This is the text file :
Pls help me on converting this text file to a csv file. Probably a script or sth to convert the text file to a csv file. (3 Replies)
Discussion started by: anaigini45
3 Replies
4. Shell Programming and Scripting
Hi Freinds
I have two .txt file gem1.txt and gem2.txt,
Sample gem1.txt
abstract (1.0.0)
actionmailer (2.3.5, 2.2.2)
actionpack (2.3.5, 2.2.2)
activerecord (2.3.5, 2.2.2)
activerecord-oracle_enhanced-adapter (1.1.9)
activerecord-sqlserver-adapter (2.3.4)
activeresource (2.3.5, 2.2.2)... (3 Replies)
Discussion started by: ankit_view24
3 Replies
5. Shell Programming and Scripting
Hi All,
I have two input file and need to generate a CSV file. The existing report just "GREP" the records with the Header and Tailer records with the count of records.
Now i need to split the data into 25 records each in the same CSV file.
id_file (Input file )
227050994
232510151... (4 Replies)
Discussion started by: rasmith
4 Replies
6. Shell Programming and Scripting
hi..
I have a text file which looks likes this
2258
4569
1239
258
473
i need to convert it into comma seperated format
eg:2258,4569,1239,258,437
pls help (8 Replies)
Discussion started by: born
8 Replies
7. 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
8. Shell Programming and Scripting
Hi Everyone ,
Below is output from a TL1 , I want just the NE Name: and beside that the Temperature and the voltages in a csv file , Is this possible?
> act-user:AB1S2a:ArshadFO:493::**********;
AB1S2a 2016-02-07 10:13:24
M 493 COMPLD
"ArshadFO:2016-02-07 10-04-55,0"
;... (11 Replies)
Discussion started by: adgjmpt
11 Replies
9. Shell Programming and Scripting
Hi, I would like to seek your help for a script that will extract data from log file and put it in a file.
Sample log file
2018-10-23 12:33:21 AI ERROR -- tpid: SAMPLE_TH account: 123456789 aiSessionNumber: 660640464 mapName: xxx to yyy
errorDesc: Translation Error:ErrorNumber : 993 ... (2 Replies)
Discussion started by: neverwinter112
2 Replies
10. UNIX for Beginners Questions & Answers
Hi ,
I have a Txt file which consist of 1000's of SOAP request and response and i want the file to be converted to a csv file like column a should have a soap request and column b should have the soap response . can someone assist me in achieving this please ?
Thanks (2 Replies)
Discussion started by: kumarm8
2 Replies
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)