I have well formatted data into a .csv, just I have publish the data(.csv) as it is on email in well color format.
What approach shall I use in splunk(like Dataset, lookups or anything)
CSVs don't have any "formatting" - that is entirely up to whatever tool you use (eg Excel) to render.
In fact, there is no way to encode "format" in a CSV - it's just a text file (https://en.wikipedia.org/wiki/Comma-separated_values)
Therefore, you have about two options:
Sorry I think, I confused you.
I have a comma separated .csv on my Linux prod server.
My question :
1. How shall I send that comma separated .csv file onto splunk.
2. Post I want to send the .csv data over email(in html format or color format)
So could you please let me know how shall I achieve the above two scenarios in splunk.
Appreciate your response.
There is no such thing as a "formatted" CSV file
You can get a CSV into Splunk in one of a few ways:
Once you've got it available to Splunk, you could manipulate it into a panel on a dashboard, and then schedule PDF delivery of that dashboard
But you can't "html format or color format" a CSV
A CSV is a text file
There is no "formatting" in it