Passing a token value with different spaces

[DineshElumalai]

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.

[ITWhisperer · Accepted solution]

Try something like this

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

[DineshElumalai]

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