Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

right trim at end of file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting right trim at end of file
# 1  
Old 03-15-2011
MySQL right trim at end of file
Hi,

I'have a file as below

Quote:
'table1',
'table2',
...
'table100',
I need to replace the comma at the end of the file into ) as below

Quote:
'table1',
'table2',
...
'table100')
Thanks
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Trim trailing spaces from file

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 to trim the file names?

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

Trim a file columnwise

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

Trim file using filename

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

right trim at end of file

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

Trim pathname of the file

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

trim spaces in a file

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

trim file

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

trim file name extension????

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

To Trim spaces at the end of line

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
Login or Register to Ask a Question

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)