Font Setting in a CSV file through script

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to generate .csv file

Dears,I need your help in this, I have to create a report based on the output file generated by another program. I want to write a shell script for this. The output file generated every 15 minutes but i can’t open it until the end of day so the script will get the file as an input the file will be...

2. Shell Programming and Scripting

Script to generate csv file

Dears, I am new in shell world and I need your help in this, I have to create a report based on the output file generated by another program. I want to write a shell script for this. The output file generated every 15 minutes but i can’t open it until the end of day so the script will get the...

3. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

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

4. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

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

5. Shell Programming and Scripting

Conversion of below Tabs Tex file into CSV format file : shell script needed

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

6. Shell Programming and Scripting

Script for updating a .csv file

Hello guys, I have one .csv file with all the file names(.c,.h,.sm,.txt etc)..... Now i have compared two baseline in UCM and got a report in .txt file,which looks like this...... DIFFBL INT_1029_Rel6.0.0.90@\DIR_PVOB STD_6.0.0.50_UCM@\DIR_PVOB (COMPONENT TEXT) Comparing the following: ...

7. Shell Programming and Scripting

How to convert a excel file to a .csv file from unix script

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

8. Shell Programming and Scripting

Changing font and color in log file of Script

Hi, We have process log with user defined error messages and information echos. I wanted to highlight error messgaes in that log file while writing in it. Is there any option with either echo or any other command which enables making text bold or we can change the font of body text of echo. ...

9. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

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:

LEARN ABOUT DEBIAN

text::csv::encoded::coder::encodeguess

Text::CSV::Encoded::Coder::EncodeGuess(3pm)		User Contributed Perl Documentation	       Text::CSV::Encoded::Coder::EncodeGuess(3pm)

NAME

       Text::CSV::Encoded::Coder::EncodeGuess - Text::CSV::Encoded coder class using Encode::Guess

SYNOPSIS

	   use Text::CSV::Encoded  coder_class => 'Text::CSV::Encoded::Coder::EncodeGuess';
	   use Spreadsheet::ParseExcel;

	   my $csv = Text::CSV::Encoded->new();

	   $csv->encoding( ['ucs2', 'ascii'] ); # guessing ucs2 or ascii?
	   $csv->encoding_to_combine('shiftjis');

	   my $excel = Spreadsheet::ParseExcel::Workbook->Parse( $file );
	   my $sheet = $excel->{Worksheet}->[0];

	   for my $row ( $sheet->{MinRow} .. $sheet->{MaxRow} ) {
	       my @fields;

	       for my $col ( $sheet->{MinCol} ..  $sheet->{MaxCol} ) {
		   my $cell = $sheet->{Cells}[$row][$col];
		   push @fields, $cell->{Val};
	       }

	       $csv->combine( @fields ) or die;
	       print $csv->string, "
";
	   }

DESCRIPTION

       This module is inherited from Text::CSV::Encoded::Coder::Encode.

USE

       Except for 2 attributes, same as Text::CSV::Encoded::Coder::Encode.

   encoding_in
	   $csv = $csv->encoding_in( $encoding_list_ref );

       The accessor to an encoding for pre-parsing CSV strings.  If no encoding is given, returns current $encoding, otherwise the object itself.

	   $encoding_list_ref = $csv->encoding_in()

       When you pass a list reference, it might guess the encoding from the given list.

	   $csv->encoding_in( ['shiftjis', 'euc-jp', 'iso-20022-jp'] );

       If it cannot guess the encoding, the first encoding of the list is used.

   encoding
	   $csv = $csv->encoding( $encoding_list_ref );
	   $encoding_list_ref = $csv->encoding();

       You can pass a list reference to this attribute only:

	 * For list data consumed by combine().
	 * For list reference returned by getline().

       In other word, in "combine" and "print", it might guess an encoding for the passing list data.  If it cannot guess the encoding, the first
       encoding of the list is used.

SEE ALSO

       Encode, Encode::Guess

AUTHOR

       Makamaka Hannyaharamitu, <makamaka[at]cpan.org>

COPYRIGHT AND LICENSE

       Copyright 2008-2010 by Makamaka Hannyaharamitu

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

perl v5.14.2							    2010-04-26			       Text::CSV::Encoded::Coder::EncodeGuess(3pm)

UNIX for Dummies Questions & Answers