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

anydata::format::csv

AnyData::Format::CSV(3pm)				User Contributed Perl Documentation				 AnyData::Format::CSV(3pm)

NAME

	AnyData::Format::CSV - tiedhash & DBI/SQL access to CSV data

SYNOPSIS

	use AnyData;
	my $table = adTable( 'CSV', $filename,'r',$flags );
	while (my $row = each %$table) {
	   print $row->{name},"
" if $row->{country} =~ /us|mx|ca/;
	}
	# ... other tied hash operations

	OR

	use DBI
	my $dbh = DBI->connect('dbi:AnyData:');
	$dbh->func('table1','CSV', $filename,$flags,'ad_catalog');
	my $hits = $dbh->selectall_arrayref( qq{
	    SELECT name FROM table1 WHERE country = 'us'
	});
	# ... other DBI/SQL operations

DESCRIPTION

       This is a plug-in format parser for the AnyData and DBD::AnyData modules. It will read column names from the first row of the file, or
       accept names passed by the user.  In addition to column names, the user may set other options as follows:

	 col_names   : a comma separated list of column names
	 eol	     : the end of record mark, 
 by default
	 quote_char  : the character used to quote fields " by default
	 escape_char : the character used to escape the quote char, " by default

       If you are using this with DBD::AnyData, put ad_ in front of the flags, e.g.  ad_eol.

       Please refer to the documentation for AnyData.pm and DBD::AnyData.pm for further details.

AUTHOR &; COPYRIGHT
       copyright 2000, Jeff Zucker <jeff@vpservices.com> all rights reserved

perl v5.10.1							    2004-08-17						 AnyData::Format::CSV(3pm)

UNIX for Dummies Questions & Answers