topic Re: Passing a token value with different spaces in Splunk Cloud Platform

Passing a token value with different spaces

DineshElumalai — Tue, 02 Apr 2024 07:55:23 GMT

Hello

I've sample data with exactly 10 characters with the combination of alphabet (2-4 characters) followed by spaces (2-4 characters) and number (2-4 characters). Refer table for sample field values. underscore represents a space.

SI.No	ID
1	ABCD__1234
2	AB____1234
3	ABCD___123
4	ABCDE__123

In dashboard, I've got filter for ID. The requirement is user can enter single or two spaces between the ABCD and 1234 in the filter box. By passing this token value with irrespective space values we need to fetch the results. Thank you.

Re: Passing a token value with different spaces

ITWhisperer — Tue, 02 Apr 2024 13:36:21 GMT

Try something like this

| eval check=replace($token$," +","\s+") | where match(ID, check)

Re: Passing a token value with different spaces

DineshElumalai — Mon, 08 Apr 2024 08:59:29 GMT

Initially I was facing error. I passed token inside the quotes "$token$". That worked for me. Thanks a lot.