Rename Pairs - file names with comma ","

[nevaeh]

Hello,

I'm trying to rename some video files using folder pairs and am having issues with filenames that contain commas.

For example, the following filename: Family Guy - S04E18 - The Father, the Son and the Holy Fonz.mkv renames to Family Guy - S04E18 - The Father.

I'm using the .csv function, specifically with Excel, where one column has the initial filename and the second column has the new filename. If I open the .csv in Notepad++, here is the output:

Code: Select all

Family.Guy.S04E18.The.Father.the.Son.and.the.Holy.Fonz.1080p.DSNP.WEB-DL.AAC2.0.H.264-PHOENiX.mkv,"Family Guy - S04E18 - The Father, the Son and the Holy Fonz.mkv"

[TheGhost78]

The format should be:

Family.Guy.S04E18.The.Father.the.Son.and.the.Holy.Fonz.1080p.DSNP.WEB-DL.AAC2.0.H.264-PHOENiX.mkv|Family Guy - S04E18 - The Father, the Son and the Holy Fonz.mkv

[nevaeh]

Per the built-in help file:

To use this facility, create a text file in for the correct format, for example:



Track001.mp3|Headlong.mp3

Track002.mp3|Rushes.mp3

TRACK003.mp3|AnywhereIs.mp3


or use comma separated (CSV)


Track001.mp3,Headlong.mp3

Track002.mp3,Rushes.mp3

TRACK003.mp3,AnywhereIs.mp3

Regardless, I tried changing the , to a | and now the file isn't matched for rename. Here is the revised statement:

Code: Select all

Family.Guy.S04E18.The.Father.the.Son.and.the.Holy.Fonz.1080p.DSNP.WEB-DL.AAC2.0.H.264-PHOENiX.mkv|Family Guy - S04E18 - The Father, the Son and the Holy Fonz.mkv

[nevaeh]

Sorry for the double post, I did end up getting it to match correctly with the "|", so thank you for that.

Does this mean the help file is incorrect and .csv files with separated with "," cannot be used?

[TheGhost78]

It appears to be incorrect, yes.

[TheGhost78]

Put each match on a new line in the CSV file, e.g.

Row 1: Track001.mp3|1, Headlong.mp3
Row 2: Track002.mp3|2, Rushes.mp3
Row 3: Track003.mp3|3, Anywhere Is.mp3

[nevaeh]

Put each match on a new line in the CSV file, e.g.

Row 1: Track001.mp3|1, Headlong.mp3
Row 2: Track002.mp3|2, Rushes.mp3
Row 3: Track003.mp3|3, Anywhere Is.mp3

Thank you for the response, my CSV file was already set up that way per the documentation, so I don't think it's a formatting issue, this seems to be a bug in BRU, specifically when using CSV files where a comma is used at the separator (as opposed to "|" ) and the file name also has commas. I assume the program instead of matching one comma per line, seems to be matching any comma in the file name as well, which would explain why BRU will partially rename the file up until the comma.

i.e., Family Guy - S04E18 - The Father, the Son and the Holy Fonz.mkv is renamed to Family Guy - S04E18 - The Father.

[Admin]

Hi! I believe that if the filenames have commas, then the filenames need to be quoted with " " when using in a CSV. Or use | as separator instead of the comma. | is an illegal character for filenames so it cannot be confused.

[nevaeh]

Hi! I believe that if the filenames have commas, then the filenames need to be quoted with " " when using in a CSV. Or use | as separator instead of the comma. | is an illegal character for filenames so it cannot be confused.

Thank you for the reply, I did indeed have the filename in quotes, here is the full line:

Code: Select all

Family.Guy.S04E18.The.Father.the.Son.and.the.Holy.Fonz.1080p.DSNP.WEB-DL.AAC2.0.H.264-PHOENiX.mkv,"Family Guy - S04E18 - The Father, the Son and the Holy Fonz.mkv"

In fact, Excel did this for me automatically, but BRU did not rename as expected.

[Admin]

Thanks, I will have a look, if quoted then it should be OK.

[ttc526]

Hi, i have the same problem with the pair renaming function.
I tried text file, csv file also did not work.
the file got loaded into it, but nothing changed.

below are the example of the format within my text file:

TRD/3408/DAN-1454/SK-0251A.pdf|ACM/3133/PC-TRC/A/DR/3625001-DAN-B1.pdf
TRD/3408/DAN-1454/SK-0252A.pdf|ACM/3133/PC-TRC/A/DR/3625201-DAN-C2.pdf

[TheGhost78]

The forward slash (solidus / 47 / u002F) is not allowed in Windows filenames. Maybe replace with a dash?

[Admin]

The issue with quotes (") in file names imported with CSV files is fixed in build 4.0.0.6
Thank you for reporting this.

[nevaeh]

The issue with quotes (") in file names imported with CSV files is fixed in build 4.0.0.6
Thank you for reporting this.

Thank you very much! I await patiently for the new build to be available for download.

[Admin]

Released:
viewtopic.php?f=1&t=6903