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 PHP

fbsql_next_result

FBSQL_NEXT_RESULT(3)							 1						      FBSQL_NEXT_RESULT(3)

fbsql_next_result - Move the internal result pointer to the next result

SYNOPSIS

       bool fbsql_next_result (resource  $result)

DESCRIPTION

	When  sending  more  than  one	SQL statement to the server or executing a stored procedure with multiple results will cause the server to
       return multiple result sets. This function will test for additional results available form the server. If an additional result  set  exists
       it will free the existing result set and prepare to fetch the words from the new result set.

PARAMETERS

	      o $
		result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).

RETURN VALUES

	Returns TRUE if an additional result set was available or FALSE otherwise.

EXAMPLES

       Example #1

	      fbsql_next_result(3) example

	      <?php
	      $link = fbsql_connect("localhost", "_SYSTEM", "secret");
	      fbsql_select_db("MyDB", $link);
	      $SQL = "Select * from table1; select * from table2;";
	      $rs = fbsql_query($SQL, $link);
	      do {
		  while ($row = fbsql_fetch_row($rs)) {
		  }
	      } while (fbsql_next_result($rs));
	      fbsql_free_result($rs);
	      fbsql_close($link);
	      ?>

PHP Documentation Group 												      FBSQL_NEXT_RESULT(3)