Add columns to a field in shell script

Question

How can I add 6 more single space separated columns to a file.

The input file that looks like this:

-11.160574
...
-11.549076
-12.020907
...
-12.126601
...
-11.93235
...
-8.297653

Where ... represents 50 more lines of numbers.

The output I want is this:

-11.160574 1  1  1 1 1 14
...
-11.549076 51 51 1 1 1 14
-12.020907 1  1  2 2 1 14
...
-12.126601 51 51 2 2 1 14
...
-11.93235 1  1  51 51 1 14
...
-8.297653  51 51 51 51 1 14

The 2nd and 3rd columns are loops for 1 to 51.

The 4th and 5th columns are also loops for 1 to 51, but at the upper level from above.

The last two ones constants columns of 1 and 14.

Shouldn't it be 49 more lines?

Thor
– Thor

2013-02-28 13:15:13 +00:00
Commented Feb 28, 2013 at 13:15 — Thor
– Thor, Commented Feb 28, 2013 at 13:15
Because is for Petrel processing

user2118994
– user2118994

2013-02-28 14:41:18 +00:00
Commented Feb 28, 2013 at 14:41 — user2118994
– user2118994, Commented Feb 28, 2013 at 14:41
I would recommend awk...

anishsane
– anishsane

2013-02-28 15:12:14 +00:00
Commented Feb 28, 2013 at 15:12 — anishsane
– anishsane, Commented Feb 28, 2013 at 15:12

John Zwinck · Accepted Answer · 2013-02-28 12:15:23Z

2

Here you go, an awk script:

{
    mod = 51
    a = (NR - 1) % mod + 1
    b = int((NR - 1) / mod) + 1
    c = 1
    d = 14
    print $0,a,a,b,b,c,d
}

Run it with something like awk -f the-script.awk in-file.txt. Or make it executable and add #!/usr/bin/awk -f at the top, and you can run it directly without typing awk -f.

answered Feb 28, 2013 at 12:15

John Zwinck

252k44 gold badges346 silver badges459 bronze badges

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

1 Comment

user2118994 Over a year ago

great ! thank-you very much, it workd pretty good, there's a '^M' character just after the first column.

dogbane · Accepted Answer · 2013-02-28 12:13:07Z

1

Use a loop to read the file line-by-line and maintain counters to keep track of the field numbers as shown below:

#!/bin/bash
field1=1
field2=1
while read line
do
    echo "$line $field1 $field1 $field2 $field2 1 14"
    (( field1++ ))
    if (( $field1 == 52 )); then
        field1=1
        (( field2++ ))
    fi
done < file

answered Feb 28, 2013 at 12:13

dogbane

276k77 gold badges406 silver badges415 bronze badges

1 Comment

user2118994 Over a year ago

it works great also ! as the awk script I have to get rid of the '^M' character touching the first column

Collectives™ on Stack Overflow

Add columns to a field in shell script

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related