I'd like to perform a mass renaming of all files in the lightroom database From: xxx_2.nef To : xxx.nef
I.e, for each image, if the name contains _2, then remove it.
Which tables and columns would be appropriate to hit?
Ended up using sql lite to open up the .lrcat file: Ran this query to fix the issue:
update AgLibraryFile
set basename = substr(basename, 0, length(basename) -1),
idx_filename = substr(basename, 0, length(basename) -1) || '.' || extension,
lc_idx_filename = substr(basename, 0, length(basename) -1) || '.' || extension,
originalFileName = substr(basename, 0, length(basename) -1) || '.' || extension
WHERE basename like '%-2'