Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

edit field using sed or awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting edit field using sed or awk
# 15  
Old 03-04-2011
Quote:
Originally Posted by ctsgnb
Code:
echo "NAME TYPE" | cat - infile

---------- Post updated at 09:27 AM ---------- Previous update was at 09:22 AM ----------

Code:
nawk 'NR<2{print "NAME TYPE"}1' infile

thanks bro...its work perfect
# 16  
Old 03-04-2011
Hi,

Can you explain me the below code?
Code:
sed 's/\(0\{4\}\)//'

[/QUOTE]
# 17  
Old 03-04-2011
sed 's/\(0\{4\}\)//' is the complicated way to say
sed 's/0\{4\}//' which is the complicated way to say
sed 's/0000//' wich is a simple way to say "replace by nothing" (=delete) the first occurrence of the string "0000" in the scanned line
# 18  
Old 03-07-2011
Quote:
Originally Posted by zulabc
please help me to edit the second field using awk or sed
i have input file below
Code:
aa1001       000001
bb1002       000002
cc1003       000003

so i want the output file like below
Code:
aa1001       01
bb1002       02
cc1003       03

i still have a problem with this..

let say my input file
aaaaaa 000001
bbbbbb 000002
cccccc 000027
dddddd 000352

when i use this code
awk '$2="0"($2+0)' file

the output file below
aaaaaa 01
bbbbbb 02
cccccc 027
dddddd 0352

how to remove all the 0s
# 19  
Old 03-07-2011
Code:
awk '$2=$2+0' file

# 20  
Old 03-07-2011
Quote:
Originally Posted by yinyuemi
Code:
awk '$2=$2+0' file

sorry my mistake i want the output file as below
aaaaaa 01
bbbbbb 02
cccccc 27
dddddd 352
# 21  
Old 03-07-2011
Code:
awk '$2=($2>10)?$2+0:"0"$2+0' file

This User Gave Thanks to yinyuemi For This Post:
zulabc
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SED/AWK to edit/add field values in a record

Hi Experts, I am new to shell scripting. Need some help in doing one task given by the customer. The sample record in a file is as follows: 3538,,,,,,ID,ID1,,,,,,,,,,, It needs to be the following: 3538,,353800,353800,,,ID,ID1,,,,,COLX,,,,,COLY, And i want to modify this record in... (3 Replies)
Discussion started by: sugarcane
3 Replies

2. Shell Programming and Scripting

Field overwrite using sed or awk

Is there a way to overwrite a specific field (i.e. line 2 field 3 without getting its contents). For example I would like to simply have a compatible Solaris 10 command line that replaces line 2 field 3 with contents of a variable. I would like to use SED or AWK if possible, but other suggestions... (1 Reply)
Discussion started by: thibodc
1 Replies

3. Shell Programming and Scripting

Inline edit using sed / awk

Hi, I have file with all the lines as following format <namebindings:StringNameSpaceBinding xmi:id="StringNameSpaceBinding" name="ENV_CONFIG_PATH" nameInNameSpace="COMP/HOD/MYSTR/BACKOFFICE/ENV_CONFIG_PATH" stringToBind="test"/> I want to replace (all the lines) value of... (8 Replies)
Discussion started by: shuklaa02
8 Replies

4. Shell Programming and Scripting

Sed or Awk or both to edit file

What is an efficient way to remove all lines from the input file which contain a file name? inputfile: ======================= # comment # comment # comment 5 8 10 /tmp 5 8 10 /var/run 5 8 10 /etc/vfstab 5 8 9 /var/tmp 5 8 10 /var/adm/messages... (7 Replies)
Discussion started by: Arsenalman
7 Replies

5. Shell Programming and Scripting

Conditional edit for a field using sed

Hi I want to repalce a field in a txt file on solaris with say 100 records and each record having a total of 10 fields separated by a ~ . based on the following condition the record should be edited or else the record should be written as it is to a if the seventh field is 'XX' and if... (2 Replies)
Discussion started by: acharania2011
2 Replies

6. Linux

awk/sed for splitting a field into two

I have a tab delimitted dataset with 4 fields. I like to split the second field into two, and have 5 fields. I like to remove the "-" sign when I get a new fiel. would you help? It is like: 1223 100-5 rr dd I need it like: 1223 100 5 rr dd (2 Replies)
Discussion started by: sire
2 Replies

7. Shell Programming and Scripting

File edit with awk or sed

I have the follwoing file: This looks to be : seperated. For the first field i want only the file name without ".txt" and also i want to remove "+" sign if the second field starts with "+" sign. Input file: Output file: Appreciate your help (9 Replies)
Discussion started by: pinnacle
9 Replies

8. Shell Programming and Scripting

edit entire column from a fixed-width file using awk or sed

Col1 Col2 Col3 Col4 12 Completed 08 0830 12 In Progress 09 0829 11 For F U 07 0828 Considering the file above, how could i replace the third column the most efficient way? The actual file size is almost 1G. I am... (10 Replies)
Discussion started by: tamahomekarasu
10 Replies

9. UNIX for Dummies Questions & Answers

Adding a new field using sed or awk?

I have a bcp file that contains 10 fields. These fields are separated by a tab. How can I add my name as a new field in the 8th position for every record? I've been playing w/ sed and awk but can't seem to figure this out. (3 Replies)
Discussion started by: sasabune
3 Replies

10. Shell Programming and Scripting

sed / awk - inplace or inline edit

I need to remove the '&' from a file. In each line of the file, the fields are separated by ^K. I only want to remove '&' if it exists in field number 9. (example of field 9: abc&xyz) I need to do an in place/in line edit. So far I have accomplished the following: awk -F '^K' '{print... (6 Replies)
Discussion started by: hemangjani
6 Replies
Login or Register to Ask a Question