These forums are read-only. Please send questions and feedback by email.

Display only the search-hit records

Use this forum to ask any questions and to submit bug reports

Moderator: vuser

djbeam
Posts: 12
Joined: Fri Jun 24, 2011 6:06 am

Display only the search-hit records

Postby djbeam » Sat Sep 12, 2015 9:59 am

If you have a CSV or Text file .. is there way to display only those records within the file (assuming a LFCR or CR delimiter) that meet a search criteria and display them in the sequence found or using the sort capabilities within V.

FileViewer
Site Admin
Posts: 287
Joined: Fri Apr 30, 2010 5:50 pm

Re: Display only the search-hit records

Postby FileViewer » Sat Sep 12, 2015 6:57 pm

is there way to display only those records within the file (assuming a LFCR or CR delimiter) that meet a search criteria and display them in the sequence found

No, you can't do this, but there is a workaround.

You can create a new file which contains just the records that match your search criteria.

To do this:

  • Select Find Files/GREP from the toolbar while you are viewing the CSV file (or press Ctrl+Shift+F) and select the Text Search tab
  • Enter your search criteria and then enable Limit To and select Current File from the list
  • Then press Search
  • After the search has finished, right click on the search results and select Copy Search Results->Copy ALL Results to a File
The new file will the contain all the records that match your search criteria.

Note that before doing the search you should select the Options tab of GREP and disable File Path and Line Number from Include in Copied Text. If you don't disable these, each line in the file will contain the file name and line number and the file will no longer be a valid CSV file.


Return to “General Support”

Who is online

Users browsing this forum: No registered users and 24 guests