FILE1
Hostname,Port,Name,Status,Vlan,Duplex,Speed,Type
shintstat,Te1/1 , Trunk- , connected , trunk , full , 10G , 10GBase-CU 3M,
shintstat,Te1/2 , Trunk , connected , trunk , full , 10G , 10GBase-CU 3M,
shintstat,Te1/3 , Trunk , connected , trunk , full , 10G , 10GBase-CU 3M,
shintstat,Te1/4 , Trunk , connected , trunk , full , 10G , 10GBase-CU 3M,
FILE2:
VLAN,Name,Status,Ports,Device
1,default,active,Te1-7 Te1-8 Te1-10 Te1-11 Te2-2 Te2-4 Te2-5 Te2-7 Te2-8 Te3-2 Te3-3 Te3-4 Te4-2 Te4-3 Te4-4 Gi5-8 Gi5-9 Gi5-10 Gi5-11 Gi5-14 Gi5-15 Gi5-16 Gi5-18 Gi5-19 Gi5-20 Gi5-22 Gi5-23 Gi5-25 Gi5-26 Gi5-27 Gi5-28 Gi5-29 Gi5-30 Gi5-31 Gi5-32 Gi5-33 Gi5-34 Gi5-35 Gi5-36 Gi5-37 Gi5-38 Gi5-39 Gi5-40 Gi5-41 Gi5-42 Gi5-43 Gi5-44 Gi5-45 Gi5-46 Gi6-3 Gi6-4 Gi6-5 Gi6-6 Gi6-7 Gi6-8 Gi6-9 Gi6-10 Gi6-11 Gi6-12 Gi6-13 Gi6-14 Gi6-15 Gi6-16 Gi6-17 Gi6-18 Gi6-19 Gi6-20 Gi6-26 Gi6-27 Gi6-28 Gi6-30 Gi6-32 Gi6-33 Gi6-34 Gi6-35 Gi6-36 Gi6-38 Gi6-39 Gi6-40 Gi6-47 Gi7-1 Gi7-16 Gi7-17 Gi7-19 Gi7-20 Gi7-21 Gi7-23 Gi7-24 Gi7-28 Gi7-29 Gi7-30 Gi7-40,./CoreTech.logshvlan.txt
10,Data,active,Gi5-12 Gi7-8 Gi7-10 Gi7-11 Gi7-12,./CoreTech.logshvlan.txt
11,VLAN0011,active,,./CoreTech.logshvlan.txt
16,stuff,active,,./CoreTech.logshvlan.txt
17,morestuff,active,,./CoreTech.logshvlan.txt
19,morestuff,active,,
------ Post updated at 05:52 PM ------
Quote:
Originally Posted by
vgersh99
Did you do the same to file1?
Did you specified NEW/converted files on the awk's cli?
Looks like you have a trailing , in file1?
Also, please get accustomed to used code tags in your posts!
Sorry, new to the forum. I will respect the code tags moving forward.
Yes, I formatted both files and used them with the same command shown