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 NETBSD

release_savepoint

RELEASE 
SAVEPOINT(7)						   SQL Commands 					      RELEASE SAVEPOINT(7)

NAME

       RELEASE SAVEPOINT - destroy a previously defined savepoint

SYNOPSIS

       RELEASE [ SAVEPOINT ] savepoint_name

DESCRIPTION

       RELEASE SAVEPOINT destroys a savepoint previously defined in the current transaction.

       Destroying a savepoint makes it unavailable as a rollback point, but it has no other user visible behavior. It does not undo the effects of
       commands executed after the savepoint was established.  (To do that, see ROLLBACK TO SAVEPOINT  [rollback_to_savepoint(7)].)  Destroying  a
       savepoint when it is no longer needed allows the system to reclaim some resources earlier than transaction end.

       RELEASE SAVEPOINT also destroys all savepoints that were established after the named savepoint was established.

PARAMETERS

       savepoint_name
	      The name of the savepoint to destroy.

NOTES

       Specifying a savepoint name that was not previously defined is an error.

       It is not possible to release a savepoint when the transaction is in an aborted state.

       If multiple savepoints have the same name, only the one that was most recently defined is released.

EXAMPLES

       To establish and later destroy a savepoint:

       BEGIN;
	   INSERT INTO table1 VALUES (3);
	   SAVEPOINT my_savepoint;
	   INSERT INTO table1 VALUES (4);
	   RELEASE SAVEPOINT my_savepoint;
       COMMIT;

       The above transaction will insert both 3 and 4.

COMPATIBILITY

       This  command conforms to the SQL standard. The standard specifies that the key word SAVEPOINT is mandatory, but PostgreSQL allows it to be
       omitted.

SEE ALSO

       BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)], ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)], SAVEPOINT [savepoint(7)]

SQL - Language Statements					    2010-05-14						      RELEASE SAVEPOINT(7)