Awk printing each line in file seperatly

Question

I am making a script that takes a list of zones records and values and puts it in a DNS server. The formatting for the wanted output is just for ansible, the problem is i get that i can't operate on each line seperatly with awk. What it does is when i don't mention a NR it prints all the items in the same line. When i mention an NR it prints either nothing or only the specified NR (Ie only if i do NR==1 it will print the first line) My objective is to iterate on all lines and print them in the format i want with newline after end of line.

bash_script

#! /bin/bash

read -p "File: " file
zone=`awk 'NR==1 { print $2}' ${file}`
echo "${zone}:" >> /etc/ansible/roles/create_dns/defaults/main/${zone}.yml

lines=`wc -l < ${file}`
for line_num in $(seq 1 $lines)
do
        echo $line_num
        echo `awk 'NR==$line_num {print "  - { zone: \x27" $2"\x27, record: \x27" $1"\x27, value: \x27" $3"\x27 }\\n"}' ${file}` >> /etc/ansible/roles/create_dns/defaults/main/${zone}.yml
done

$file

ansible ben.com 10.0.0.10
test ben.com 10.0.0.110
example ben.com 10.0.0.120

Wanted output:

ben.com:
  - { zone: 'ben.com', record: 'ansible', value: '10.0.0.10' }
  - { zone: 'ben.com', record: 'test', value: '10.0.0.110' }
  - { zone: 'ben.com', record: 'example', value: '10.0.0.120' }

Output i get:

ben.com:

You should copy/paste your shell scripts into http://shellcheck.net and fix the bugs it tells you about. — Ed Morton, Jun 30 '21 at 13:11
Regarding `\x27` in your awk script - use `\047` instead, see http://awk.freeshell.org/PrintASingleQuote for details. — Ed Morton, Jun 30 '21 at 13:12
Regarding `$line_num` in your awk script, use `-v ...` instead - see [how-do-i-use-shell-variables-in-an-awk-script](https://stackoverflow.com/questions/19075671/how-do-i-use-shell-variables-in-an-awk-script) — Ed Morton, Jun 30 '21 at 13:13

anubhava · Answer 1 · 2021-06-30T14:47:18.923

4

You can use this single awk for this:

read -p "File: " file
awk '{printf "\t- { zone: \047%s\047, record: \047%s\047, value: \047%s\047 }\n", $2, $1, $3 > $2}' "$file"
cat ben.com

   - { zone: 'ben.com', record: 'ansible', value: '10.0.0.10' }
   - { zone: 'ben.com', record: 'test', value: '10.0.0.110' }
   - { zone: 'ben.com', record: 'example', value: '10.0.0.120' }```

edited Jun 30 '21 at 14:47

answered Jun 30 '21 at 08:30

anubhava

761,203
64
569
643

RavinderSingh13 · Accepted Answer · 2021-06-30T14:23:11.597

With your shown samples, please try following solution. This is a Generic solution, on basis of, you could give a number of column names in BEGIN section of this program under split section, but this is considering that you want to add strings(eg: zone, record etc) before each field/column values. IN case your number of strings are lesser than number of fields/columns in Input_file then you can change condition from i<=NF too as per your need, to fetch how many columns you want to get.

read -p "File: " file
awk -v s1='\047' 'BEGIN{OFS=", ";split("zone:,record:,value:",headings,",")} {for(i=1;i<=NF;i++){$i=headings[i]" " s1 $i s1};$0="  - { " $0" }"} 1' "$file"

Adding a non one liner form of solution here:

awk -v s1="'" '
BEGIN{
  OFS=", "
  split("zone:,record:,value:",headings,",")
}
{
  for(i=1;i<=NF;i++){
    $i=headings[i]" " s1 $i s1
  }
  $0="  - { " $0" }"
}
1
' "$file"

Awk printing each line in file seperatly

2 Answers2