rm SUP/*
awk -F"^" ' NR>1 {
file = "SUP/H"sprintf("%.4d",NR)
print "H01"$2 > file
nom=$4" "$5" "$7
print "H02"nom > file
if ($9!="") a="Suite "$9
else a=""
print "H03"$8" "a > file
print "H05"$10 > file
print "H06"$11"-"$12 > file
print "H07"$14 > file
print "H08"$15 > file
print "">file
close(file)
} ' Suppl.csv
>../data/suppl/H
>../data/suppl/HEAD
echo -n "    0     0">../data/suppl/INFO
for i in SUP/*
do
../ihd/bin/ihmu suppl ../../import/$i -N1
done
exit
Customer Number^First Name^Middle Initial^Last Name^Company^Street^Suite^City^State^Zip/Postal Code^Phone^Cell_Phone^Business_Phone
1^Garlike^^Virginia^^3893 Pecan Circlenmnnkn^^La Porte^TX^77034^(281) 941-9695^(832) 646-2300^
2^Gerald^^Flowers^^3650 Burke Road^^Pasadena^TX^77504^(281) 691-2231^^
10001^Ralph & Judy^^Carmona^^10611 Steppinstone Court^^Spring^TX^77379^(281) 924-3661^(281) 924-3668^(281) 931-6609
10002^Edith^l^Langdon^^1219 Azaua Court^^Pasadena^TX^77506^(713) 473-8431^^
10004^Ivy^^Montemouyor^^1311 Heights^^Pasadena^TX^77503^(713) 472-7538^^
10005^Frances^^Mereno^^1804 Sullivan^^Pasadena^TX^77506^^(832) 830-4327^
10006^Maria^^Salazar^^^^Pasadena^TX^77506^(713) 447-3746^^
10007^Maria^^Salazar^^2003 N. Palm Court^^Pasadena^TX^77502^(832) 725-4516^^
10008^Frances^^Mereno^^1804 Sullivan Ave^^Pasadena^TX^77506^(832) 830-4327^^
