Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sed help adding parenthesis
Top Forums Shell Programming and Scripting sed help adding parenthesis Post 302834591 by BeefStu on Friday 19th of July 2013 10:39:42 AM
Old 07-19-2013
sed help adding parenthesis
I have the following data and want to put parenthis around the numbers:

Code:
 
PARTITION PERIOD_MIN   VALUES LESS THAN 10649 TABLESPACE ODS_DAILY_MF_AUM,
 PARTITION PERIOD_10649 VALUES LESS THAN 10650 TABLESPACE ODS_DAILY_MF_AUM,
 PARTITION PERIOD_10650 VALUES LESS THAN 10651 TABLESPACE ODS_DAILY_MF_AUM,
...
...
...

The output should look like this

Code:
 
PARTITION PERIOD_MIN   VALUES LESS THAN (10649) TABLESPACE ODS_DAILY_MF_AUM,
 PARTITION PERIOD_10649 VALUES LESS THAN (10650) TABLESPACE ODS_DAILY_MF_AUM,
 PARTITION PERIOD_10650 VALUES LESS THAN 1(0651)TABLESPACE ODS_DAILY_MF_AUM,
...
...
...

Can somebody provide me with a SED or AWK statement that can do this in one shot.

Thanks to all who answer
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

another sed question about parenthesis

hi, I'm trying to use sed to erase everything, up to, and including, the first closing parenthesis. for example: input: blah blah blah (aldj) test (dafs) test test. output: test (dafs) test test. how would i do this? I was fooling around with the parenthesis, and i only got it to apply to... (5 Replies)
Discussion started by: gammaman
5 Replies

2. UNIX for Dummies Questions & Answers

sed - adding new line

I want to use sed to look for spaces in text and when find one move the next word to the next line. I used: sed 's/ /\n/g' out > new However when there is more than one space between two words it adds more lines between them. And I just want the words to be one under another. How can I... (2 Replies)
Discussion started by: sovixi
2 Replies

3. Shell Programming and Scripting

sed for adding word

hello i have a file (myfile) contains line as follows /home/mytarget/myproject i want to add a pattern at the end of this line. my pattern is- /.*mk i want like it - /home/mytarget/myproject/*.mk i tried sed like sed 's/$//*.mk/' myfile > newfilename, but not wrking. pls... (2 Replies)
Discussion started by: shailesh_arya
2 Replies

4. Shell Programming and Scripting

adding another field to SED output

Dear experts, I have a file called "check" with contents like below i used the sed command like below to get the value of "success" and "failed" only My question is how can i get the value to include the time "03:15", so that i can get a value such as below : - Appreciate... (4 Replies)
Discussion started by: aismann
4 Replies

5. Shell Programming and Scripting

Multiline parenthesis matching, with e.g. SED script, in LaTeX doc

In a LaTeX manuscript, I need to replace many occurrences of \emph{some string} with some string, i.e. whatever string is inside. The string inside often may extend over several lines, and there may be other occurences of curly brackets inside it. So for example \emph{this \it{is} a... (5 Replies)
Discussion started by: sune
5 Replies

6. UNIX for Dummies Questions & Answers

Adding space after character using sed?

dears i have the data below, i want a command ( i think it should be sed) that add a space after the seconds as below : Jun 24 22:28:18966568406148@ Jun 24 05:47:35966555747744@ Jun 24 05:47:53966560825239@ Jun 24 06:07:52966541147164@ Jun 24 15:49:55966566478883@ thanks... (5 Replies)
Discussion started by: thehero
5 Replies

7. Shell Programming and Scripting

sed adding a blank line

I use the following as part of a script to correct for a faulty hostname file. # get the domain name read -r thehostname < /etc/hostname dom="$(echo $thehostname | cut -d'.' -f2)" numchar=${#dom} if then echo "It appears as though the hostname is not correctly set." echo "Hostname has... (5 Replies)
Discussion started by: bugeye
5 Replies

8. Shell Programming and Scripting

adding text with sed

sed 's/<\/body>/<A HREF='"$index"'>'"$description"'<\/A>\ <\/body>/' "$index" This will work from the command prompt, but not from my ksh script. Why not? sed: command garbled: s/<\/body>/<A HREF=/accounts/students/b/bmwg6c/public_html/index.html>I would like to call it white... (4 Replies)
Discussion started by: robin_simple
4 Replies

9. Shell Programming and Scripting

Need help with Sed (replacing parenthesis and comma)

I have the following text as an input text: input.txt Results('Toilet', 'Sink', ) and i want to remove the last comma so the output is output.txt Results('Toilet', 'Sink' ) I tried using the following sed command, but I get a parsing error: sed s/, \)/\)/g input.txt >... (5 Replies)
Discussion started by: jl487
5 Replies

10. Shell Programming and Scripting

adding a number with sed or awk.

Hi.. I have this delicate problem..:wall: I have this huge ldif file with entry's like this example below.. And I need to change the following entrys. telephoneNumber: emNotifNumber: billingnumber= BillingNumber: Al these entrys has a number like 012345678 and it needs to add one more... (15 Replies)
Discussion started by: pelama
15 Replies

LEARN ABOUT SUSE

alter_tablespace

ALTER 
TABLESPACE(7)						   SQL Commands 					       ALTER TABLESPACE(7)

NAME

       ALTER TABLESPACE - change the definition of a tablespace

SYNOPSIS

       ALTER TABLESPACE name RENAME TO newname
       ALTER TABLESPACE name OWNER TO newowner

DESCRIPTION

       ALTER TABLESPACE changes the definition of a tablespace.

       You  must  own  the tablespace to use ALTER TABLESPACE.	To alter the owner, you must also be a direct or indirect member of the new owning
       role.  (Note that superusers have these privileges automatically.)

PARAMETERS

       name   The name of an existing tablespace.

       newname
	      The new name of the tablespace. The new name cannot begin with pg_, as such names are reserved for system tablespaces.

       newowner
	      The new owner of the tablespace.

EXAMPLES

       Rename tablespace index_space to fast_raid:

       ALTER TABLESPACE index_space RENAME TO fast_raid;

       Change the owner of tablespace index_space:

       ALTER TABLESPACE index_space OWNER TO mary;

COMPATIBILITY

       There is no ALTER TABLESPACE statement in the SQL standard.

SEE ALSO

       CREATE TABLESPACE [create_tablespace(7)], DROP TABLESPACE [drop_tablespace(7)]

SQL - Language Statements					    2010-05-14						       ALTER TABLESPACE(7)
All times are GMT -4. The time now is 11:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy