Shell Programming and Scripting

I am having some issues with a script taking in column #5 which has a space and splitting it into another line. I don't want this but I can not figure out why its doing this. Any help is appreciated.


Here is my input file (comma delimited):

Vendor_ext_AltMfg_6.6.6.6,host,6.6.6.6,255.255.255.255,olive drab,EOC

Here is my script:

#!/bin/bash
#
# ------>>>>> This assumes that the hosts.csv file is comma delimited <<<<<-------
#


for i in `cat drab.txt`; do
name=`echo $i | awk -F, '{ print $1 }'`
ip=`echo $i | awk -F, '{ print $3 }'`
mask=`echo $i | awk -F, '{ print $4 }'`
color=`echo $i | awk -F, '{ print $5 }'`

echo "create host_plain $name" >> /fwlogs/dbedit/dbedit_add_hosts_script.txt

echo "modify network_objects $name ipaddr $ip" >> /fwlogs/dbedit/dbedit_add_hosts_script.txt

echo "modify network_objects $name color $color" >> /fwlogs/dbedit/dbedit_add_hosts_script.txt

echo "update network_objects $name" >> /fwlogs/dbedit/dbedit_add_hosts_script.txt

done

echo "quit -update_all" >> /fwlogs/dbedit/dbedit_add_hosts_script.txt

Here is the output I get where the column #5 with the space gets split into another line:

create host_plain Vendor_ext_AltMfg_6.6.6.6
modify network_objects Vendor_ext_AltMfg_6.6.6.6 ipaddr 6.6.6.6
modify network_objects Vendor_ext_AltMfg_6.6.6.6 color olive
update network_objects Vendor_ext_AltMfg_6.6.6.6
create host_plain drab
modify network_objects drab ipaddr
modify network_objects drab color
update network_objects drab
quit -update_all

Code:

#!/bin/sh

echo "Vendor_ext_AltMfg_6.6.6.6,host,6.6.6.6,255.255.255.255,olive drab,EOC" | (
IFS=,
while read A B C D E F G H
do
   echo A=$A
   echo B=$B
   echo C=$C
   echo D=$D
   echo E=$E
   echo F=$F
done
)

Thanks for the quick reply. I don't know how to get your solution working with multiple lines.

how do I use that with multiple input lines in the input file? I want to parse the input file to make a text file formated in my above original script?

Vendor_1_1.1.1.1,host,1.1.1.1,255.255.255.255,olive drab,EOC
Vendor_2_2.2.2.2,host,2.2.2.2,255.255.255.255,green,EOC
Vendor_3_3.3.3.3,host,3.3.3.3,255.255.255.255,blue,EOC
Vendor_4_4.4.4.4,host,4.4.4.4,255.255.255.255,black,EOC
Vendor_5_5.5.5.5,host,5.5.5.5,255.255.255.255,white,EOC
Vendor_6_6.6.6.6,host,6.6.6.6,255.255.255.255,orange,EOC

Code:

#!/bin/sh

IFS=,
export IFS
while read A B C D E F G H
do
   echo A=$A
   echo B=$B
   echo C=$C
   echo D=$D
   echo E=$E
   echo F=$F
done <<EOF
Vendor_1_1.1.1.1,host,1.1.1.1,255.255.255.255,olive drab,EOC
Vendor_2_2.2.2.2,host,2.2.2.2,255.255.255.255,green,EOC
Vendor_3_3.3.3.3,host,3.3.3.3,255.255.255.255,blue,EOC
Vendor_4_4.4.4.4,host,4.4.4.4,255.255.255.255,black,EOC
Vendor_5_5.5.5.5,host,5.5.5.5,255.255.255.255,white,EOC
Vendor_6_6.6.6.6,host,6.6.6.6,255.255.255.255,orange,EOC 
EOF

works great!!! Thanks for the quick help!! Much appreciated!!