How to split data with awk

Question

I would like to use awk to work on some files. I have a file like this:

input:

a     2   16  
b    17   25   
c    26   32   
d    33   51

and what I want is to split all rows to enumerate the range between column 2 and column 3, incrementing the numbers by 2. For example:

a  2  4  6  8 10 12 14 16  
b  17 19 21 23 25  
c  26 28 30 32  
d  33 35 37 39 41 43 45 47 49 51

Please show your attempt, we're not here to do your work for you. If you can't get it working, we'll help you fix it. — Barmar
– Barmar, Commented Jan 27, 2015 at 17:38
what should happen if $2 is odd and $3 is even, for example, so the range isn't a multiple of 2? — Ed Morton
– Ed Morton, Commented Jan 27, 2015 at 20:13

user448810 · Accepted Answer · 2015-01-27 17:50:14Z

4

$ awk ' { printf("%-3s", $1)
>         for (i=$2; i<=$3; i+=2)
>             printf ("%-3d", i)
>         printf("\n") } ' <<EOF
> a   2  16
> b   17 25
> c   26 32
> d   33 51
> EOF
a  2  4  6  8  10 12 14 16
b  17 19 21 23 25
c  26 28 30 32
d  33 35 37 39 41 43 45 47 49 51

answered Jan 27, 2015 at 17:50

user448810

17.9k4 gold badges38 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

glenn jackman Over a year ago

You can use print "" in place of printf("\n") -- a little tidier.

Collectives™ on Stack Overflow

How to split data with awk

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related