Tuesday, 8 March 2016

Text processing 1

Input File (username.txt):


TilottamaChatterjee     D0:53:49:18:AB:D6       10.0.12.80
AtulDeokar      4c:bb:58:06:79:ec       10.0.12.81
DeepakSant      4C:BB:58:14:C7:42       10.0.12.82
VipinTergaonkar E0:06:E6:D3:89:2D       10.0.12.83
KunalRaut       DC:85:DE:A0:88:55       10.0.12.84
NayanPanchal    C0:38:96:97:10:9D       10.0.12.85
SandeepTandale  94:39:E5:D3:BB:65       10.0.12.86
PraneetSamaiya  64:5a:04:34:8a:d6       10.0.12.87


Desired Output:

name:TilottamaChatterjee
mac: D0:53:49:18:AB:D6
ip: 10.0.12.80
name:AtulDeokar
mac: 4c:bb:58:06:79:ec
ip: 10.0.12.81
name:DeepakSant
mac: 4C:BB:58:14:C7:42
ip: 10.0.12.82
name:VipinTergaonkar
mac: E0:06:E6:D3:89:2D
ip: 10.0.12.83
name:KunalRaut
mac: DC:85:DE:A0:88:55
ip: 10.0.12.84
name:NayanPanchal
mac: C0:38:96:97:10:9D
ip: 10.0.12.85
name:SandeepTandale
mac: 94:39:E5:D3:BB:65
ip: 10.0.12.86
name:PraneetSamaiya
mac: 64:5a:04:34:8a:d6
ip: 10.0.12.87


Script:

#!/bin/sh
# On terminal, fire the command 'sh loop.sh > output.ldif'.
EMAILFILE=username.txt


for x in `grep -v ^# $EMAILFILE | awk 'BEGIN { OFS = ";"; ORS = "\n\n" } { print $1,$2,$3 }'`; do

> var.txt
echo "$x" > var.txt
a=`cut -d ';' -f1 var.txt`;
y=`cut -d ';' -f2 var.txt`;
z=`cut -d ';' -f3 var.txt`;



echo "name:$a
mac: $y
ip: $z"
done

No comments: