Analyze some Data - Parse raw log data into CSV format.

I have a raw file full of entries about 3GB in size. I have tried using log parser however this is not a standardised file format so it must be formatted. Space " " is used as a delimited however some fields have countries made of two worlds "United Kingdom" which will contain a space. I need a simple script (Visual Basic Script, Batch, PowerShell or whichever) that will be able to go through the entire log file, determine the fields and generate me a CSV file with the data in the correct fields. Here is a sample file. Each paragraph represents an entry row. Some entries do not have the same fields, some entries have fields in different orders. May 11 00:00:00 [login to view URL] date=2015-05-11 time=00:00:00 devname=DEMO-unit1 devid=FG200B3912608545 logid=0000000013 type=traffic subtype=forward level=notice vd=root srcip=[login to view URL] srcport=50427 srcintf="port15" dstip=[login to view URL] dstport=53 dstintf="port16" sessionid=756474921 status=accept policyid=1 dstcountry="Ireland" srccountry="Reserved" trandisp=snat transip=[login to view URL] transport=50427 service=DNS proto=17 duration=180 sentbyte=81 rcvdbyte=128 sentpkt=1 rcvdpkt=1 May 11 00:00:05 [login to view URL] date=2015-05-11 time=00:00:05 devname=DEMO-unit1 devid=FG200B3912608545 logid=0001000014 type=traffic subtype=local level=notice vd=root srcip=[login to view URL] srcport=55906 srcintf="port15" dstip=[login to view URL] dstport=161 dstintf="root" sessionid=756475176 status=accept policyid=0 dstcountry="Reserved" srccountry="Reserved" trandisp=noop service=SNMP proto=17 app=SNMP duration=180 sentbyte=180 rcvdbyte=349 sentpkt=1 rcvdpkt=2 May 11 00:00:10 [login to view URL] date=2015-05-11 time=00:00:10 devname=DEMO-unit1 devid=FG200B3912608545 logid=0000000013 type=traffic subtype=forward level=notice vd=root srcip=[login to view URL] srcport=137 srcintf="port15" dstip=[login to view URL] dstport=137 dstintf="port15" sessionid=756485114 status=deny policyid=0 dstcountry="Reserved" srccountry="Reserved" trandisp=noop service=137/udp proto=17 duration=0 sentbyte=0 rcvdbyte=0 May 11 00:00:19 [login to view URL] date=2015-05-11 time=00:00:19 devname=DEMO-unit1 devid=FG200B3912608545 logid=0000000013 type=traffic subtype=forward level=notice vd=root srcip=[login to view URL] srcport=59107 srcintf="port15" dstip=[login to view URL] dstport=111 dstintf="Manchester-p1" sessionid=756476011 status=accept policyid=190 dstcountry="Reserved" srccountry="Reserved" trandisp=noop service=ONC-RPC proto=17 duration=180 sentbyte=84 rcvdbyte=0 sentpkt=1 rcvdpkt=0 vpn="Manchester-p1" vpntype=ipsec-static The script should try and automatically detect the fields without inputting them manually. The end results should be something like this. month ¦ day ¦ hour ¦ ip ¦ date ¦ time May ¦ 11 ¦ 00:00:10 ¦ [login to view URL] ¦ 2015-05-11 ¦ 00:00:19 May ¦ 11 ¦ 00:00:10 ¦ ¦ 2015-05-11 ¦ 00:00:19 That should be the end result. The second result has no IP. This means that the actual entry in the raw log file does not have the ip entry. Most of the fields are identifiable as "field=data".