Splunk Search

How to format text extracted from a lookup?

ChrisCLewis
Communicator

Good afternoon,

I have text in a lookup.csv that has hard returns in it, for example:

This is the reason why the sun is hot:
reason 1.
reason 2.
reason 3.

But the result from the lookup turns the hard returns into spaces turning it into a single long sentence, for example:

This is the reason why the sun is hot: reason 1. reason 2. reason 3.

Is there a way to keep the hard returns (special characters in the CSV) or to put them in post lookup?

Many thanks for your time.

0 Karma

to4kawa
Ultra Champion
...
| append [|inputlookup lookup.csv]

and stats etc...

0 Karma

dsctm3
Path Finder

Is it possible your lookup is using Windows text format on a Splunk instance installed on *nix?

If so, consider using the dos2unix command on the lookup file. (You may need to install if from yum/apt)

0 Karma

ChrisCLewis
Communicator

The value of the lookup is being sent to a token if that makes things easier / more difficult

0 Karma
Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...