Format csv file using Unix

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Change date format in am/pm in csv files using UNIX

Hi All, I'm new to forum good to hear all. I stuck in converting date format in csv file using unix csv file contains as below ,750,0000000000000000GCJR, ,06/22/2016 14:48:44 I want to convert into as below ,750,0000000000000000GCJR, ,06/22/2016 02:48:44 PM Please reply asap.....

2. Shell Programming and Scripting

UNIX command output in csv format

I'm just wondering is there any way to capture the output of a unix command in a csv format. df -h gives the result of filesystem,free space,Used space, use %,mounted on. Is there a way to capture the command output and format it as comma sparated or fixed length file.

3. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy...

4. Shell Programming and Scripting

Format csv file

Hi, I need to make some changes in a csv file using awk or perl. Unfortunately, all my attempts have led to nothing so I hope you guys can help me. I have the following example input file including header(original file has 35 fields): ABC: DE Time: 2012/09/07...

5. Shell Programming and Scripting

Retaining the Unix CSV format in Excel format while exporting

Hi All, I have created a Unix Shell script whch creates a *.csv file and export it to Excel. The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example : if the Amount has the value as 3000000 User wants to be in 3,000,000 format. This Amount format...

6. Shell Programming and Scripting

Convert the below file to csv format

Hi , i want to change this question, i will post soon..

7. Shell Programming and Scripting

Format CSV file

I have a csv file which I need to process and export back to xlsx file. For instance, the csv contains: John Smith, job-title, hours John Smith, job-title, hours Mary Smith job-title, hours etc. I need to import that to a script, get id of redundant data i.e: John smith, job-title,...

8. UNIX for Dummies Questions & Answers

Unix script to convert .csv file to.xls format

I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format. Its very urgent please help me.

9. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

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

10. Shell Programming and Scripting

FORMAT OF CSV FILE under unix environment.

hi I unload the table results from oracle to csv file foramt. i need increse the width of each column using unix commands could you pl tell me how to increase the width of each column to spefic width uisng sed unix command or na other unix commands i have file name called report.csv inside...

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 Desktop Questions & Answers