UNIX for Beginners Questions & Answers

Hi

How do I print character after colon":"
below is input file

Code:

BUC1  : 33157147, BUC1 COUNT : 478455,BUC1 : 9930334.18
BUC2  : 1203100,BUC2 COUNT : 318678,BUC2 GIVEN : 3493491.59
BUC3  : 234567.99

expected output

Code:

 
33157147 478455 9930334.18
12031002 318678 3493491.59
234567.99

try this:

Code:

tr -s ',' ' ' < filename | 
awk '{ for (i=1;i<=NF;i++)
       { if($(i)==":"){printf("%s ",$(i+1) ) }
       }
       printf("\n")
     }'

You could also use -F '[ ,]' as the field separator instead of using tr but not all awk implementations support regexes for specifying FS.

something along these lines:

Code:

awk -F'[:,]' '{for(i=1;i<=NF;i=i+2) printf("%s%s", $(i+1), (i+2>NF)?ORS:OFS)}' myFile

Another approach:

Code:

awk -F, '{gsub(/[^,]*: /,x); $1=$1}1' file

--
or

Code:

sed 's/[^,]*: //g; s/,/ /g' file

Hi Scrutinizer

below command works for me but can you please explain me . I am not able to understand it. like what is the use of

Code:

[^,]*

Code:

//g;

Code:

s/,/ /g'

Code:

 
 sed 's/[^,]*: //g; s/,/ /g' file

In sed, and other tools such as grep and awk, [] is a character class - a character that can match anything inside the brackets. This can be a list, a range, or a combination of the two. If the first character after the left bracket is a carat (^) you invert the class, so the above matches anything except the comma. The asterisk is a special character that tells sed to match the previous character zero or more times. So [^,]* could match anything up to and not including a comma, or anything after a comma. delete Change comma to space Delete all strings in the line that don't include the comma and end in ": ";
Change all commas to spaces.

Andrew

Hi Andrew,

thx a lot, you explained it very well.
however I am still not able to understand explanation for this

Code:

 //g;

.

i an not able to understand the working as per below explanation

Code:

Delete all strings in the line that don't include the comma and end in ": ";

it will be really helpful to me if you explain it again for me

thx in advanced
Scriptor