Add character to specific columns using sed or awk and make it a permanent change


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add character to specific columns using sed or awk and make it a permanent change
# 8  
Old 10-20-2015
I know this doesn't work, my question is how to do the, if not, THEN in sed? I guess I use the branching but had less than success with it, anyway let me know.
Code:
sed -n 'p;/{/ !s/^/#/; s/^\(.*\)/# \1/' file6

If not
Code:
{

then add
Code:
#

with the other sustitute statement. Thanks

P.S. Simply put, If I am too confusing maybe show me how to do this particular example with sed, the original question.
# 9  
Old 10-20-2015
Quote:
Originally Posted by Klasform
I know this doesn't work, my question is how to do the, if not, THEN in sed? I guess I use the branching but had less than success with it, anyway let me know.
Code:
sed -n 'p;/{/ !s/^/#/; s/^\(.*\)/# \1/' file6

If not
Code:
{

then add
Code:
#

with the other sustitute statement. Thanks

P.S. Simply put, If I am too confusing maybe show me how to do this particular example with sed, the original question.
That is not the original question. The original question was how to put an octothorps at the start of every line that contains the string beautiful. The obvious way to do that in sed is:
Code:
sed '/beautiful/s/^/#/' file

but the original request was also to put the results back in the input file. Just using standard sed features (i.e., no -i option), that can be done with:
Code:
sed '/beautiful/s/^/#/' file > file.$$ && cp file.$$ file;rm -f file.$$

But, if you did want to add an octothorpe to the lines that do NOT contain beautiful, you can do that in sed with:
Code:
sed '/beautiful/n;s/^/#/' file

# 10  
Old 10-20-2015
Sorry Don will ask the question as a new one,
thanks
# 11  
Old 10-20-2015
Code:
while read line
do
   echo "$line" |grep beautiful >/dev/null 2>&1
   if [ $? = 0 ]
   then
     echo "#$line"
   else
     echo "$line"
   fi
done <a.sh

If you want to write it using a script.
# 12  
Old 10-21-2015
Rudic can you explain !s
sed '/{/ !s/^/#/' file

Last edited by Don Cragun; 10-21-2015 at 04:47 AM.. Reason: Remove broken QUOTE tags.
# 13  
Old 10-21-2015
Quote:
Originally Posted by ashima jain
Rudic can you explain !s
sed '/{/ !s/^/#/' file
From the standards:
Quote:
A function can be preceded by one or more '!' characters, in which case the function shall be applied if the addresses do not select the pattern space. Zero or more <blank> characters shall be accepted before the first '!' character. It is unspecified whether <blank> characters can follow a '!' character, and conforming applications shall not follow a '!' character with <blank> characters.
Or, translated from standardese, perform the specified substitution (insert an octothorpe at the start of a line) on lines that do not contain an open brace character.
This User Gave Thanks to Don Cragun For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Add specific text to columns in file by sed

What is the proper syntax to add specific text to a column in a file? Both the input and output below are tab-delineated. What if there are multiple text/fields, such as /CP&/2 /CM&/3 /AA&/4 Thank you :). sed 's/*/Index&/1' del.txt.hg19_multianno.txt > matrix.del.txt (4 Replies)
Discussion started by: cmccabe
4 Replies

2. Shell Programming and Scripting

How to print with awk specific field different from specific character?

Hello, i need help with awk. I have this file: cat number DirB port 67 er_enc_out 0 er_bad_os 0 DirB port 71 er_enc_out 56 er_bad_os 0 DirB port 74 er_enc_out 0 er_bad_os 0 DirB port 75 ... (4 Replies)
Discussion started by: elilmal
4 Replies

3. UNIX for Dummies Questions & Answers

Will authconfig make permanent change or lost after reboot?

Hi, I made following configuration to create user directory: # authconfig --enablemkhomedir --update But the directory is created as permission 755, I'd like to modify the script to change directory access permission to 700, where is the script which copies /etc/skel to /home... (0 Replies)
Discussion started by: hce
0 Replies

4. Shell Programming and Scripting

change character(s) in specific column

Hi all! I need to change the final e every time when it is present in any word in column 1 to a; moreover, to change the final i again to a in any word in column 1, but just if word in column 2 begins with ha or si. Here below you can see a sample of my data: achwa ungeliachwa ungeli 1... (3 Replies)
Discussion started by: mjomba
3 Replies

5. Shell Programming and Scripting

Selecting specific 'id's from lines and columns using 'SED' or 'AWK'

Hello experts, I am new to this group and to 'SED' and 'AWK'. I have data (text file) with 5 columns (C_1-5) and 100s of lines (only 10 lines are shown below as an example). I have to find or select only the id numbers (C-1) of specific lines with '90' in the same line (of C_3) AND with '20' in... (6 Replies)
Discussion started by: kamskamu
6 Replies

6. Shell Programming and Scripting

AWK or SED to add string at specific position

Greetings. I don't have experience programing scripts. I need to insert a string in a specific position of another string on another file (last.cfg), for example: File last.cfg before using script: login_interval=1800 lcs.machinename=client04 File last.cfg after using script:... (4 Replies)
Discussion started by: vanesuke
4 Replies

7. Emergency UNIX and Linux Support

awk- add columns and make new column and save as newfile

Hi, I have file as below: 5 6 7 4 8 9 3 5 6 output needs to be another file with 4th column as $1+$2 and 5th column as $3+$4. sample output file 5 6 7 11 18 4 8 9 12 21 3 5 6 8 14 Anybody have answer Thanks in advance (3 Replies)
Discussion started by: vasanth.vadalur
3 Replies

8. Shell Programming and Scripting

Using sed to replace specific character and specific position

I am trying to use sed to replace specific characters at a specific position in the file with a different value... can this be done? Example: File: A0199999123 A0199999124 A0199999125 Need to replace 99999 in positions 3-7 with 88888. Any help is appreciated. (5 Replies)
Discussion started by: programmer22
5 Replies

9. Shell Programming and Scripting

How to change a specific character in a file

Hi, I have a data file with following structure: a|b|c|d|3|f1|f2|f3 a|b|c|d|5|f1|f2|f3|f4|f5 I want to change this data to: a|b|c|d|3|f1;f2;f3 a|b|c|d|5|f1;f2;f3;f4;f5 Data in column 5 tells the number of following fields. All fields delimiter after the 5th column needs to be... (6 Replies)
Discussion started by: sdubey
6 Replies

10. UNIX for Dummies Questions & Answers

How to make ulimit change permanent

ulimit -a gives the following output:$ulimit -a time(seconds) unlimited file(blocks) 2097152 data(kbytes) 131072 stack(kbytes) 16384 memory(kbytes) unlimited coredump(blocks) 32768 nofiles(descriptors) 400 vmemory(kbytes) 147456 Abot output... (3 Replies)
Discussion started by: nervous
3 Replies
Login or Register to Ask a Question