Miscellanous Features
This section is for features that don't clearly fit in any of the other categories.
Web URLs
Modern CSV can open websites in your default browser.
Go to URLs
Follow Selected Hyperlink(s) (ctrl+r) will take you to whatever URLs are in the selected cells.
Follow Selected Hyperlink(s) (cmd+r) will take you to whatever URLs are in the selected cells.
Web search
Web Search for Selected Terms opens a browser and performs web searches in separate tabs for each selected cell.
You change the search engine with the Search Engine setting. The default is duckduckgo.com. It's easiest to use the Set Search Engine command because it gives you several pre-defined options including:
- duckduckgo.com
- bing.com
- google.com
- yahoo.com
You can also enter a custom domain in case you want to use another search engine. Optionally, you may include the resource/parameter key part (e.g. the /search?q= part of google.com.au/search?q=). If you don't include it, it's assumed to be /search?q=. Optionally, you may include the https:// and/or the www. part.
Map Search
Web Search for Selected Places in Map opens a browser and performs map searchs in separate tabs for each selected cell.
You change the map with the Online Map setting. The default is duckduckgo.com. It's easiest to use the Set Search Engine command because it gives you several pre-defined options including:
- duckduckgo.com
- bing.com
- google.com
You can also enter a custom domain in case you want to use another online map. Optionally, you may include the resource/parameter key part (e.g. google.co.za/search?q=). If you don't include it, it's assumed to be /search?q=. Optionally, you may include the https:// and/or the www. part.
Open the file in an external text editor
Open File in Text Editor opens the current file, as saved on disk, in an external text editor of your choice. The default text editors, by platform, are:
- Windows: Notepad
- Mac: TextPad
- Linux: gedit
You can change the text editor with the Set Text Editor command.
Column Lookup
The Column Lookup is similar to VLOOKUP in spreadsheet programs. It can pull in data from other files or the same file.
With Column Lookup, there are two "key" columns that contain the same data, usually a unique ID. One contains the "from" (or source) keys and the other contains the "to" (or destination) keys. It looks up the values in the same rows as the the "from" keys and places them in the same rows as their respective "to" keys.
You can decide which columns are the "value" columns, there may be more than one, and they do not have to be adjacent to each other. You can also decide where the values should be placed. When they are placed, they will be adjacent to each other, even if they weren't adjacent originally. You are also given the choice whether they should overwrite existing columns or new columns should be inserted.
If a "to" key doesn't have a matching "from" key, it's values are left empty.
Here are the queries you will have to answer when using this command:
- Select the File to Look Up Data From.
- Enter the Key Column in the Lookup File.
- Enter the Value Column(s) in the Lookup File.
- File to Write Data To.
- Enter the Key Column in the Destination File.
- Enter the Value Column in the Destination File.
- Do you want to insert new columns or overwrite existing columns?
You can either type columns in (e.g. 3-6, 8, 10) or select them in the table. When selecting them, be sure to click back on the query and hit enter.
Since there are so many steps, it lists out the previous reponses. If you need to go back, you can click on them or hit ctrl+left.
Since there are so many steps, it lists out the previous reponses. If you need to go back, you can click on them or hit cmd+left.
Example
Suppose we have this data in the "From" file.
| ID (From) | First Name | Last Name |
|---|---|---|
| 1 | Angus | Young |
| 2 | Cliff | Williams |
| 3 | Malcolm | Young |
| 4 | Brian | Johnson |
| 5 | Phil | Rudd |
| 6 | Bon | Scott |
We set the ID (From) as the Lookup Key and the First Name and Last Name columns as the Source Value columns.
The destination file looks like this:
| ID (To) | ||
|---|---|---|
| 3 | ||
| 5 | ||
| 6 | ||
| 1 | ||
| 2 | ||
| 4 |
When we set the ID (To) column as the Destination Key and its adjacent columns as the Destination Value columns, we get this:
| ID (To) | ||
|---|---|---|
| 3 | Malcolm | Young |
| 5 | Phil | Rudd |
| 6 | Bon | Scott |
| 1 | Angus | Young |
| 2 | Cliff | Williams |
| 4 | Brian | Johnson |
Even though the IDs are in different orders, the values are with their corresponding IDs.