Difference between revisions of "ReNamer:Rules:CSV-Import"

From den4b Wiki
Jump to: navigation, search
(Created page with "See Export menu<BR> There is an "Import file names from text-list (CSV or TXT)" option:<BR> > Imports file paths and new names from the .csv (comma separated) or .txt (tab sep...")
 
Line 3: Line 3:
 
> Imports file paths and new names from the .csv (comma separated) or .txt (tab separated) file.<BR>
 
> Imports file paths and new names from the .csv (comma separated) or .txt (tab separated) file.<BR>
 
http://www.den4b.com/wiki/ReNamer:Export_menu<BR><BR>
 
http://www.den4b.com/wiki/ReNamer:Export_menu<BR><BR>
 +
 +
 +
<BR>
 +
 +
<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>
 +
<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>
 +
<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>
 +
For example:<BR>
 +
"C:\My Folder\My Old File.txt","My New File.txt"<BR>
 +
"C:\My Folder\My Old File 2.txt","My second New File.txt"<BR>
 +
"C:\My Folder\My Old File 3.txt","My Another New File.txt"<BR>
 +
<BR>
 +
See this article for more examples:<BR>
 +
https://en.wikipedia.org/wiki/Comma-separated_values#Basic_rules<BR>
 +
<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>
 +
ReNamer v7.1.0.2 Beta handles unquoted values appropriately, so you don't need to manually enquote all values any more.<BR>
 +
<BR>
 +
 +
<BR>
 +
 +
<BR>
 +
 +
<BR>
 +
 +
<BR>

Revision as of 11:59, 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





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 v7.1.0.2 Beta handles unquoted values appropriately, so you don't need to manually enquote all values any more.