10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I have a file like this.
hari,corporationbank,2234356,syndicate
ravi,indian bank,4567900000000,indianbank,accese
raju,statebank of hyderabad,565866666666666,pause
Here each record has different record length and there are blank spaces... (8 Replies)
Discussion started by: kshari8888
8 Replies
2. UNIX for Dummies Questions & Answers
How do i get the following output, irrespective of how many . 's i will have the file name.
Input:
FCBTexas_2013_12_31_16_V2.5_Masked.xml.filepart
Output:
FCBTexas_2013_12_31_16_V2.5_Masked.xml
Thank you. (6 Replies)
Discussion started by: Ariean
6 Replies
3. Shell Programming and Scripting
Hi All,
I want to trim each columns leading & trailing (like sql trim function) of a ',' separated file..
I've a file like this..
manab , c gi
lucky , home
babu , maa
I want the output as
manab,c gi
lucky,home
babu,maa
A one liner would be a great help. (2 Replies)
Discussion started by: manab86
2 Replies
4. UNIX for Dummies Questions & Answers
I want to remove first xx letters from filename_xx . How is that possible using linux. I have many files where xx could be same in many but filename is always unique. Thanks! (1 Reply)
Discussion started by: keysoon
1 Replies
5. Shell Programming and Scripting
Hi,
I'have a file as below
I need to replace the comma at the end of the file into ) as below
Thanks (1 Reply)
Discussion started by: dvah
1 Replies
6. Shell Programming and Scripting
I am capturing the files in a directory to an array. I have 2 arrays with list of files in two different directories. Both the directories are supposed to have the same number of files and filenames.
I want to check that the same file exists in both the directories. After I capture the... (1 Reply)
Discussion started by: Sangtha
1 Replies
7. Shell Programming and Scripting
Hi,
I'm new to shell programming. Need some help in the following requirement:
I have a file origFile.txt with values:
origFile.txt
.00~ 145416.02~ xyz~ ram kishor
.35~ 765.76~ anh reid~ kishna kerry
Now each row in the file has value for 4 columns with "~" as... (7 Replies)
Discussion started by: badrimohanty
7 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a 6G log , which is unusual to read and I want to minimize it by removing some part on the upper portion( around 4GB). what should i do? can you please help me?
thanks. (1 Reply)
Discussion started by: tungaw2004
1 Replies
9. AIX
Dear Chaps,
What will I do if, I am not sure about the length of the file name, but only one thing that I want to remove only the last extension.
e.g. abcdXXXXXX.pqrXXXXX.asc (X is any character)
I want to trim only .asc (or,watever) so that resultant file name would be like... (1 Reply)
Discussion started by: vishal_ranjan
1 Replies
10. Shell Programming and Scripting
Hi Friends,
Can any one help with this issue:
How to trim spaces for each line at the end,
Like I have a file in this format.
EMP1 SMITH 46373 5 STREET HOWARD 74636
EMP2 JONES 5454 { these are spaces ........}
EMP3 SMITH 46373 5 STREET HOWARD 74636
EMP4 JON 2554 { these are... (1 Reply)
Discussion started by: sbasetty
1 Replies
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)