Once you’re happy with the preview name, you can select the range of files you want to rename.If you’re not happy with the preview name and it doesn’t seem to do what you expected, you can manually adjust the settings and watch the preview file name change in real time. Select one of the files on the right-hand folder menu and a preview file name appears under the New Name column.The way you’re viewing this list of files will affect the order in which they’re renamed, so pay close attention to how the original files are sorted. You can sort the files in the right-hand menu by name, file type, or the date that the digital photos were modified/taken/etc.
Use the two large folder menus on the top half of the Bulk Rename Utility interface and navigate to the files you want to rename.New Location (13): Make a copy of the original files, add new file names and place them in a new folder while preserving the original files.Selections (12): Specify which files and folders are displayed in Bulk Rename Utility.Extension (11): Change the file extension (ex.Numbering (10): Add numbers to file names.Append Folder Name (9): Add a folder’s name to the name of a file within that folder – you can even add the names of main folders and subfolders into the same file name.Auto Date (8): Add dates to file names (choose between date Created, Modified, Accessed, Taken, or the Current date).Add (7): Add specific words or characters to file names.Move/Copy (6): Move or copy specific words or characters to different parts of the file name.Remove (5): Specifies characters and/or words to remove.Case (4): Sets different uppercase or lowercase options for text.(3): Finds specific text and replaces it with new text. File (2): Sets rules for the existing file name (Keep, Remove or Reverse it – or specify a new Fixed name).If you don’t know the language, leave this section alone. RegEx (1): A find-and-replace tool that uses a complex computer language called Regular Expressions.Right Navigation Pane (B): A detailed list-style view of the files and folders inside of whatever’s selected in the Left Navigation Pane.Left Navigation Pane (A): A hierarchical tree-style view of computer drives and folders.Set the new file name with tName().Ĭode snippet: const SPREADSHEET_ID = "SPREADSHEET_ID" // Change according to your preferencesĬonst SHEET_NAME = "Sheet1" // Change according to your preferencesĬonst FOLDER_ID = "DRIVE_FOLDER_ID" // Change according to your preferencesĬonst ss = SpreadsheetApp.openById(SPREADSHEET_ID) Ĭonst sheet = ss.getSheetByName(SHEET_NAME) Ĭonst folder = DriveApp.getFolderById(FOLDER_ID) Ĭonst values = sheet.getRange("A2:B" + sheet.getLastRow()).getValues() // If there's no header row, use "A:B" insteadĬonst fileIter = folder.For each row, find the folder files whose name is the value from column A, using Folder.getFilesByName.Get all sheet values with getRange().getValues().If that's the case, I'd suggest the following: If I understand this correctly, you want change names of the files in a Drive folder according to some sheet data (current name is in column A, and new name is in column B).
0 kommentar(er)
