I have a csv file with data in the following format...
logsource,Critical,Buffer Overflow,15:05:27 13 Mar 2017,,sourceserver_172.92.110.10 (172.92.110.10),,somedesthost_172.92.110.18 (172.92.110.18),",N/A/1080",Application Servers Protection Violation,buffer overflow,,,2,01548914,
logsource,Medium,Application Activity,12:11:23 31 Mar 2017,,172.92.110.83,,somedestination_172.92.110.88 (172.92.110.88),file-wbt-server [tcp/19380],,,,,22,01547076,
logsource,Informational,Application Activity,23:56:20 31 Mar 2017,India,202.91.201.54,United States,ABCDEF_172.74.18.13 (172.74.168.13),tcp/443,,,,,22,01553030,
logsource,Informational,Application Activity,23:49:22 31 Mar 2017,,somesource1_172.92.18.7 (172.92.18.7),United States,14.35.2.46,tcp/1443,,,,,3,01552984,
I need to extract the source IP address from the 6th fields in each row and save in a field "src_ip_address"
eg. from line 1, src_ip_address = 172.92.110.10
from line 2, src_ip_addres = 172.92.110.83
Similarly I need to extract the destination IP address from the 8th field and store the values in a "dst_ip_address" field
eg.
from line 1, dst_ip_address = 172.92.110.88
from line 2, dst_ip_address = 172.92.110.18
Is this possible? if yes, it will be of immense help if someone could show a clue.
Thanks !
... View more