Why is Dashboard Studio not recognizing newline?

[jinishshah]

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]

Can you please explain how you are adding the dataset and where and how you are using it?

[jinishshah]

@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

[VatsalJagani]

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.)