Visit Our UNIX and Linux User Community


Awk,sed : change every 2nd field ":" to "|"


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Awk,sed : change every 2nd field ":" to "|"
# 1  
Old 06-21-2013
Awk,sed : change every 2nd field ":" to "|"

Hi Experts,
I have a string with colon delimited, want 2nd colon to be changed to a pipe.

Code:
data:
101:8:43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3:


I am trying with sed, but can change only 1 occurance:
Code:
echo "101:8:43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3:" | sed 's/:/|/2'
101:8|43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3:



Want this for every 2nd ":" occurance to be changed to "|"

The desired output should be:
Code:
101:8|43:4|72:14|41:69|85:3|137:4|3:0|4:0|9:3|0:3|12:3|


Thanks,

---------- Post updated at 08:05 PM ---------- Previous update was at 07:42 PM ----------

I got it now with sed :

1. made a script file for sed.
Code:
cat script
s/:/|/2
s/:/|/3
s/:/|/4
s/:/|/5
s/:/|/6
s/:/|/7
s/:/|/8
s/:/|/9
s/:/|/10
s/:/|/11
s/:/|/12



2. executed the script: Got desired output.
Code:
$ awk -f script data
101:8|43:4|72:14|41:69|85:3|137:4|3:0|4:0|9:3|0:3|12:3|

# 2  
Old 06-21-2013
In case you are interested in a more compact solution which does not depend on the number of fields:
Code:
sed 's/\([^:]*:[^:]*\):/\1|/g'

Regards,
Alister
This User Gave Thanks to alister For This Post:
# 3  
Old 06-21-2013
A different type of Perl alternative (if you are interested):
Code:
perl -lpe '@a = split /(:)/, $_, -1; @a = map { ($_+1)%4 ? $a[$_] : "|" } 0..$#a if @a>3;
$_ = join("",@a)' file

This could be easily done with one regex substitution. But, the above solution is just for fun/amusement.
This User Gave Thanks to elixir_sinari For This Post:
# 4  
Old 06-22-2013
It could be shortened / simplified further a little:
Code:
sed 's/\(:[^:]*\):/\1|/g' file

or
Code:
perl -pe 's/(:.*?):/$1|/g' file

This User Gave Thanks to Scrutinizer For This Post:
# 5  
Old 06-25-2013
Alister ,
Thanks I checked the sed code works great.

Code:
sed 's/\([^:]*:[^:]*\):/\1|/g' file

Thanks,

Scrutinizer,
This code also works great, thanks a lot for the small code,
Code:
sed 's/\(:[^:]*\):/\1|/g' file

Could you guys please explain how the substitue portion working here:
(2nd ":" to "|" )

Code:
sed 's/\(:[^:]*\):/\1|/g'

I can understand that
Code:
 \1|/

is changing the first search pattern to "|" , but the regex code is little complicated seems.

---------- Post updated at 12:28 AM ---------- Previous update was at 12:18 AM ----------

Thanks to elixir_sinari , for the perl code, worked. but looks like much more complicated. : (
# 6  
Old 06-25-2013
The sed command uses a substitute command ( s/.../.../ ) . The first part of the expression contains a basic regular expression (regex). The escaped parentheses \( and \) are used to group parts of matched text that can be back referenced by \1 in the second part of the s-command.

So in this case only the second colon is outside the grouped part and does not get back referenced, so effectively it gets discarded. If we apply this to your input file then the first match is :8:, which gets substituted with :8|. At the end of the expression is the letter g, which is the "global" flag, which means that the operation should be repeated for every occurrence on the line.

So this will be repeated, and crucial here, is that the next match will start after the previous match, so next up will be :4: which becomes :4| and then :14: becomes :14| and so on...

Last edited by Scrutinizer; 06-25-2013 at 01:49 AM..

Previous Thread | Next Thread
Test Your Knowledge in Computers #109
Difficulty: Easy
The Unix shell is the interface between the user and the kernel.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

2. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address and column 3 contains “cc” e-mail address to include with same email. Sample input file, email.txt Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies

3. Shell Programming and Scripting

Find lines with "A" then change "E" to "X" same line

I have a bunch of random character lines like ABCEDFG. I want to find all lines with "A" and then change any "E" to "X" in the same line. ALL lines with "A" will have an "X" somewhere in it. I have tried sed awk and vi editor. I get close, not quite there. I know someone has already solved this... (10 Replies)
Discussion started by: nightwatchrenba
10 Replies

4. Post Here to Contact Site Administrators and Moderators

Suggestion: adding two new groups "sed" and "awk"

Majority of the questions are pertaining file/string parsing w.r.t sed or awk It would be nice to have these two as their own sub category under shell-programming-scripting which can avoid lot of duplicate posts. (1 Reply)
Discussion started by: jville
1 Replies

5. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz (8 Replies)
Discussion started by: timmywong
8 Replies

6. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

7. Shell Programming and Scripting

Simplify Bash Script Using "sed" Or "awk"

Input file: 2 aux003.net3.com error12 6 awn0117.net1.com error13 84 aux008 error14 29 aux001.ha.ux.isd.com error12 209 aux002.vm.ux.isd.com error34 21 alx0027.vm.net2.com error12 227 dux001.net5.com error123 22 us008.dot.net2.com error121 13 us009.net2.com error129Expected Output: 2... (4 Replies)
Discussion started by: sQew
4 Replies

8. Shell Programming and Scripting

Help to change the file with "sed" and "awk"

Hi experts I want your help to change the file format to my wanted version, please give me a hand thanks $cat file install pass make os pass make build kernel failed usb storage pass chane to | *install* | *make os* | *make build kernel* | *usb storage* | | pass | pass... (7 Replies)
Discussion started by: yanglei_fage
7 Replies

9. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies

10. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies

Featured Tech Videos