I have Excel file with the below three columns, i need your expertise in converting this to .csv file delimiter "|"
Excel -
Code:
Serial Number Serial Name Serial Brand
111 test sample
123 test2 sample1
134 134_test3 sample2
135 135_test4 sample3
Reuested this to converted to .csv file with delimiter "|" and for the column Serial name.. if any of the records having serial number with Serial name, the serial number should be ignored... and the desired csv file should be like below
Code:
Serial Number|Serial Name |Serial Brand
111|test|sample
123|test2|sample1
134|test3|sample2
135|test4|sample3
Last edited by Corona688; 12-20-2018 at 01:06 PM..
Reason: Code tags for code please
When I create filesystems in AIX i often get confused(using smit)
When you specify size in aix, it is asked like this
SIZE of file system (in 512-byte blocks)
I never seem to grasp this, what is the equation to get say
500mb? Or is there a program anyone knows of that does this, like a... (1 Reply)
Hello,
I transferred some .txt files from windows to Unix. When i used the editor in Unix to open up the file, all the <cr> show up. How to I get rid of all of them? (4 Replies)
I want to convert string into uppercase string. How can i do that ? Ex: Enter the user name:
read name
show=upper(name)
echo $show --- This output should be the uppercase output.
Thanks (3 Replies)
I use Sco_Sv 3.2v5.0.5 with parellel conection using dump terminals and i want to convert them to desktop pc.
Anybody knows what hardware and other thing that would be involved? (3 Replies)
Hi - I have seen some similar posts but I am a bit stumped here
below is the first line of a 'od -c filename' command. I want to change the \0 to \n
0000000 l s \0 c d - \0 c d . . \0 l s
I have tried a sed construct in a script.........
sed... (2 Replies)
Hi all,
I have never written a script so I guess you could say I am very yellow.:) However, I could use some help.... I need to write a Korn Shell Script that converts coins. Meaning if I print or echo "Please enter amount:" and the user puts in 3.87, I need to know the least amount of coins... (11 Replies)
I have a file that ends with a ctlU:
> cat -v test.file
blah,blah,blah,GEAEA*1*xx0000111xxx^UIEA*xxx0^U
would like to replace the ctlU (^U) with a "\12"...due to printers or something.
I believe I might be able to utilize the tr command, if I could only identify the correct... (4 Replies)
So i have been asked to write a script for a friend who has a server running solaris 11. My problem is the correct syntax i can't seem to get it work with the follow code, i have read through the date man page and found no work around
Below is the code for part of the rsync script.
The code i... (2 Replies)
I have a set of values separated by a tab
ch:12 1 3 4
ch:13 3 3 4
ch:25 1 8
ch:23 2 8 1
There is a missing value in the third column and i would like replace it with
NA such that the final output would look like
ch:12 1 3 ... (7 Replies)
Discussion started by: johnkim0806
7 Replies
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)