Difference between revisions of "ReNamer:Rules:CSV-Import"
m |
|||
| Line 9: | Line 9: | ||
<BR> | <BR> | ||
| + | == Example == | ||
| + | |||
| + | From http://www.den4b.com/forum/viewtopic.php?pid=10917#p10917 | ||
You can save your excel file in CSV format (comma delimited), and then use ReNamer's import/export options, such as "Import file paths and new names".<BR> | You can save your excel file in CSV format (comma delimited), and then use ReNamer's import/export options, such as "Import file paths and new names".<BR> | ||
| − | |||
Note that you will need to have a full file path in the first column, otherwise ReNamer won't know where to find the file.<BR> | Note that you will need to have a full file path in the first column, otherwise ReNamer won't know where to find the file.<BR> | ||
| − | |||
If the cell contains spaces, commas or quotation marks, then the cell value must be en-quoted and inner quotation marks escaped properly.<BR> | If the cell contains spaces, commas or quotation marks, then the cell value must be en-quoted and inner quotation marks escaped properly.<BR> | ||
<BR> | <BR> | ||
| Line 26: | Line 27: | ||
You may need to select a different variation of the CSV format when saving from Excel, to get properly en-quoted and escaped cell values.<BR> | You may need to select a different variation of the CSV format when saving from Excel, to get properly en-quoted and escaped cell values.<BR> | ||
<BR> | <BR> | ||
| − | ReNamer v7.1.0.2 Beta handles unquoted values appropriately, so you don't need to manually enquote all values any more.<BR> | + | ReNamer since v7.1.0.2 Beta handles unquoted values appropriately, so you don't need to manually enquote all values any more.<BR> |
<BR> | <BR> | ||
Latest revision as of 16:07, 25 April 2020
See Export menu
There is an "Import file names from text-list (CSV or TXT)" option:
> Imports file paths and new names from the .csv (comma separated) or .txt (tab separated) file.
http://www.den4b.com/wiki/ReNamer:Export_menu
Example
From http://www.den4b.com/forum/viewtopic.php?pid=10917#p10917
You can save your excel file in CSV format (comma delimited), and then use ReNamer's import/export options, such as "Import file paths and new names".
Note that you will need to have a full file path in the first column, otherwise ReNamer won't know where to find the file.
If the cell contains spaces, commas or quotation marks, then the cell value must be en-quoted and inner quotation marks escaped properly.
For example:
"C:\My Folder\My Old File.txt","My New File.txt"
"C:\My Folder\My Old File 2.txt","My second New File.txt"
"C:\My Folder\My Old File 3.txt","My Another New File.txt"
See this article for more examples:
https://en.wikipedia.org/wiki/Comma-separated_values#Basic_rules
You may need to select a different variation of the CSV format when saving from Excel, to get properly en-quoted and escaped cell values.
ReNamer since v7.1.0.2 Beta handles unquoted values appropriately, so you don't need to manually enquote all values any more.