Hi Can someone tell me how we can use a csv file using a lookup and extract the details from a file in a field which we can use for further calculations. Example: A csv file (dummy.csv) with the ...
See more...
Hi Can someone tell me how we can use a csv file using a lookup and extract the details from a file in a field which we can use for further calculations. Example: A csv file (dummy.csv) with the below details are saved in Splunk and we need to extract the details present in the file after the date in a new field in SPlunk and use the new field for further calculations. Data in the dummy.csv file : "Monday,01/07/2024",T2S Live Timing,"[OTHER] BILL invoice for CSDs Billing period 10-30 June ",,,,,, "Tuesday,02/07/2024",, ,,,,,, "Wednesday,03/07/2024",,"[OTHER] BILL invoice for NCBs Billing period 10-30 June",,,,,, "Thursday,04/07/2024",, ,[OTHER] DKK Service window between 19.35 - 23.59 ,,,,, "Friday,05/07/2024",T2S Synchronised Release day,,,,,,, "Saturday,06/07/2024",,[4CB] T2-T2S Site Recovery (internal technical test) ,[4CB] T2-T2S Site Recovery (internal technical test) ,,,,, "Sunday,07/07/2024",,[4CB] T2-T2S Site Recovery (internal technical test) ,[4CB] T2-T2S Site Recovery (internal technical test) ,,,,, "Monday,08/07/2024",T2S Live Timing, ,,,,,, How we can use the lookup and eval command to find the data present in the above file after the date ?? Example : Date = 01/07/2024 Output = T2S Live Timing Date = 02/07/2024 Output = Blank Space Date = 03/07/2024 Output = Blank Space Date = 04/07/2024 Output = Blank Space Date = 05/07/2024 Output = T2S Synchronised Release day