02-28-2019
strange file format "csv" you have
![Smilie Smilie](https://www.unix.com/images/smilies/smile.gif)
This User Gave Thanks to nezabudka For This Post:
10 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
Looking for any advise from a DBA/DA. When should you use CHAR and when should you use VARCHAR when designing a table. From my readings seems like VARCHAR will accept any length string even though you define a length to it, so I setup gadget VARCHAR(10) I could actually put something with 20... (1 Reply)
Discussion started by: benefactr
1 Replies
2. UNIX for Advanced & Expert Users
Hi ,
I need to sort a file based on multiple columns All the columns are of varchar type
can any one give me the command to sort for varchar columns?
Thanks (3 Replies)
Discussion started by: laxmi131
3 Replies
3. Shell Programming and Scripting
Hi
I have a file in the following format:
4135 f4135acc: 39798 rmtdb: 0 /t1/data/f4135acc.dta
4135 f4135pdb: 39795 rmtdb: 0 /bb/data/f4135pdb.dta
4135 p4135eng: 0 rmtdb: 0 /bb/bin/p4135eng
4135 r4135eng: 14142 rmtdb: 0 ... (6 Replies)
Discussion started by: aoussenko
6 Replies
4. Shell Programming and Scripting
I have cgicsave.env and cgic*, but I want to print cgic* value but NOT cgicsave.env
Thanks (9 Replies)
Discussion started by: xs2punit
9 Replies
5. Shell Programming and Scripting
hi , i am very new to perl . scriptting.. pllease can any one help me ...pleaseeeeeee
i ll have a file which look likes
123 |something |567
456 |welcome |789
457 |inboxpost |790
.
.
123 |something |567
i have to execute all the lines in the file except the first and the... (14 Replies)
Discussion started by: vishwakar
14 Replies
6. Ubuntu
I am familiar with using tar and exclude/include files:
tar zcf backup.dirs.tgz --files-from=include.mydirs --exclude-from=exclude.mydirs --no-recursion
but was wondering if I could use find in the same way. I know that you can just specify the directories to exclude but my list is... (2 Replies)
Discussion started by: metallica1973
2 Replies
7. Shell Programming and Scripting
Hi Gurus.
I have a directory and i receive many files with extension .log. I processed the file as i get it. i want to process all the files except one which i know i don't want to process.
cd /backup/temp/rajesh/PACS #--- directory , under this i have below files... (1 Reply)
Discussion started by: guddu_12
1 Replies
8. UNIX for Dummies Questions & Answers
hi,
i am trying to use a exclude file to exclude some file directories while making a tar archive. This is my command:
tar -pcvf orahome10gR2.tar.gz db_1 -X /home/oracle/excludeFile.txt /home/oracle/
when i execute it, it seem to be tar-ing. But once is done, i cd to /home/oracle and could... (2 Replies)
Discussion started by: redologger
2 Replies
9. Shell Programming and Scripting
Hello,
I have a list of patterns which I'd like to exclude from a file. I tried to do
while read line
do
grep -v $line file >> new.file
done < mylist
But obviously it won't work. It only works for just grep. I know I can do:
grep -Ev 'pattern1|pattern2|...' myfile
but my... (7 Replies)
Discussion started by: coppuca
7 Replies
10. Shell Programming and Scripting
Hello everyone,
I try to find folders older than 3 years and display them, but excluding some directories, the below code does NOT exclude listed directories:
find . -maxdepth 3 -mtime +1095 -type d -exec ls -l {} \; | grep -vFf oldExclude >> older
oldExclude
Folder1/
Folder2/... (7 Replies)
Discussion started by: Abu Rayane
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)