topic Re: Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows? in All Apps and Add-ons

Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows?

changux — Tue, 08 Nov 2016 22:34:11 GMT

Hi all.

I have a file with 200 rows and 10 columns. When I tried to make some changes, I saw that the last line is row 122 (my file has 20k). How I can adjust to show the whole file?

Thanks!

Re: Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows?

LukeMurphey — Tue, 08 Nov 2016 23:55:34 GMT

When you scroll down, more rows should appear. I just tested again on both KV and CSV lookups (the later with 100,000 rows) and it worked.

Here is an example of using the middle mouse key to scroll. Note that you need to click into the table first:

Here is an example of using the scroll-bar on the right of the table:

Re: Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows?

nikkkc — Fri, 18 Aug 2017 11:52:58 GMT

same problem here, my csv file have 500 rows and the lookup editor shows only 100 to 120 rows, it depends on every refresh

Re: Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows?

LukeMurphey — Fri, 18 Aug 2017 17:34:28 GMT

Can you scroll down to see more rows? More rows should appear once you begin to scroll.

Re: Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows?

nikkkc — Mon, 21 Aug 2017 06:27:19 GMT

Oh, it only works with internet explorer! it does not with firefox

Re: Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows?

LukeMurphey — Tue, 22 Aug 2017 16:59:04 GMT

@nikkc: are you hovering your mouse cursor over the table while you scroll? I just tried it on Firefox and it worked for me (though only when I had the cursor over the table).

Re: Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows?

e2eadmin — Thu, 26 Oct 2017 13:56:20 GMT

Yep...same. Works great in IE. Not in Chrome.

Re: Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows?

qbolbk59 — Tue, 04 Dec 2018 15:10:58 GMT

Hi @LukeMurphey ,

How can i search and edit a specific value in the lookup file. The thing is in my lookup file, there are more than 1000 rows and i wish to change value on one of the column of a particular row. But it's too difficult to find that row in the lookup.
I tried normal search (CTRL+F) in the browser but apparently it only searches values in the current view of the lookup (number of rows currently visible on screen) but if the values are somehwere below or at the top of current view, it doesn't searches.

I can search for values using inputlookup, but that's just for searching events.

How can i search and edit values in the lookup file using lookup editor app ?

Re: Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows?

LukeMurphey — Tue, 04 Dec 2018 23:41:15 GMT

I am going to convert this to a question since this is related but I think deserves its own discussion.

Re: Lookup file Editor App for Splunk Enterprise: How to edit a file with more than 120 rows?

LukeMurphey — Tue, 04 Dec 2018 23:46:47 GMT

Here is the new question: https://answers.splunk.com/answers/703714/how-can-i-search-and-edit-a-specific-value-in-the.html?childToView=703715#answer-703715

TL;DR: I'm looking into adding a feature that can do this.