UNIX for Dummies Questions & Answers

Hi All,

I have files with a column which has values and ranges, for example

colA colB
ERD1 3456
ERD2 [526887..526890]
ERD3 4456

I want to have the following output
colA colB colC
ERD1 3456 3456
ERD2 526887 526890
ERD3 4456 4456

Being a newbie to shell scripting ,I`m struggling to find the right commands.

Question 2.

I have an array of alphanumeric variables like 24S45M67N45M, 367M, 23M3D34M etc. There will be at least 1 M and at most 2 Ms in the strings
while the other alphabets may or may not be present.
I want to extract the number associated with the Ms. So the output will look like
24S45M67N45M 45 45
367M 367 0
23M3D34M 23 34

Please help !

Thanks,
Alpesh

So the ou at least 1

Q1 :

Code:

sed '1s/.*/& colC/;s/[][]//g;s/\.\./ /' yourfile

Q2 :

Code:

$ for v in 24S45M67N45M 367M 23M3D34M
> do
> echo $v | nawk -F"M" '{gsub(/[0-9][0-9]*[^0-9M]/,z);print($1+0),($2+0)}'
> done
45 45
367 0
23 34

---------- Post updated at 11:04 PM ---------- Previous update was at 11:01 PM ----------

Also using the '+' from the regular expression extended character set :

Code:

$ for v in 24S45M67N45M 367M 23M3D34M
> do echo $v | nawk -F"M" '{gsub(/[0-9]+[^0-9M]/,z);print($1+0),($2+0)}'
> done
45 45
367 0
23 34

---------- Post updated at 11:10 PM ---------- Previous update was at 11:04 PM ----------

If you still want to display the initial value of the variable :

Code:

$ for v in 24S45M67N45M 367M 23M3D34M; do echo $v | nawk -FM '{x=$0;gsub(/[0-9]+[^0-9M]/,z);print x,($1+0),($2+0)}'; done
24S45M67N45M 45 45
367M 367 0
23M3D34M 23 34

---------- Post updated at 11:20 PM ---------- Previous update was at 11:10 PM ----------

Ooops i just realize that Q1 requires a fix :

Code:

nawk 'NR<2{print $0,colC;next}{gsub(/[][]/,z);sub(/\.\./,FS);$0=$0;print $1,$2,$NF}' yourfile

Thanks ctsgnb . nawk doesnt work for my system but awk does