leegin · October 15, 2019 14:15
diff --git a/txt_to_json.sh b/txt_to_json.sh
 #/bin/bash
 #Script to parse the log to get IP address and URL and then convert it to json

 read -p "Enter the name of the log file which you want to parse: " file

 less $file  | awk '{print $1","$15}' | grep http | cut -d ")" -f1 | sed 's/+//'  > data.txt
 jq -Rs '[ split("\n")[] | select(length > 0) | split(",") | {IP_address: .[0], URL: .[1]}  ]' data.txt > data.json
	#/bin/bash
	#Script to parse the log to get IP address and URL and then convert it to json

	read -p "Enter the name of the log file which you want to parse: " file

	less $file \| awk '{print $1","$15}' \| grep http \| cut -d ")" -f1 \| sed 's/+//' > data.txt
	jq -Rs '[ split("\n")[] \| select(length > 0) \| split(",") \| {IP_address: .[0], URL: .[1]} ]' data.txt > data.json