When I just display field "Writeup" from my Excel dataset which is like below:
"This is the first line.
This is the second line.
This is the third line."
While displaying the same in Dashboard Studio, it prints like below:
"This is the first line.This is the second line.This is the third line."
How can I resolve this issue
@VatsalJagani : Sorry for late reply. Dataset is an excel file. Below are more details
Excel file name: Writeup.csv
Data:
Header Month Writeup
Autosys 01-2022 There are many Autosys failures this month as compared to previous.
Main reason of failure is Server reboot.
All host issues have been resolved and numbers would do down this month
Query: | inputlookup Writeup.csv | where month="01-2022" and Header="Autosys"| fields Writeup
O/P:
There are many Autosys failures this month as compared to previous. Main reason of failure is Server reboot. All host issues have been resolved and numbers would do down this month
Expected O/P:
There are many Autosys failures this month as compared to previous.
Main reason of failure is Server reboot.
All host issues have been resolved and numbers would do down this month
Ideally when you have a newline character in your CSV file.
Open that CSV file in a text editor (notepad, notepad++, etc), and your line should read something like:
Autosys,01-2022,"There are many Autosys failures this month as compared to previous.\n Main reason of failure is Server reboot.\n All host issues have been resolved and numbers would do down this month"
\n represents a newline character.
(Though, I'm not sure which component of Splunk Dashboard Studio treats \n as a newline character and which treats it as text.)