Prefix the file names in a folder with sequential numbers based on the highest number already used as a prefix

Question

Prefix the file names in a folder with sequential numbers based on the highest number already used as a prefix

I've successfully used a script to rename the 10 files in a folder by adding '1 - ' to the beginning of each file name. However, I have encountered two issues:

When I run the script again, it mistakenly adds another 'X - ' at the start, resulting in names like '1 - 2 - XXXX'
I want to modify the script so that if a file already has a prefix like '1 - ', it won't be renamed again.
Additionally, when new files are added to the folder, I want them to continue the numbering from the last file. For example:

Folder currently contains:

1 - XXXX 2 - XXXX 3 - XXX

If I add a fourth file and run the script, the output should be:

1 - XXXX 2 - XXXX 3 - XXX 4 - XXX

Existing files remain unchanged while the new file starts at 4.

Any assistance would be greatly appreciated!

UPDATE: I have also included the link to my current script as requested: enter image description here

javascript google-apps-script

Answer 1

Answer №1

Check out the following solution:

function renumerate_files() {
  var folder = DriveApp.getFolderById('###'); // input your folder ID here
  var files_in_folder = folder.getFiles();
  var files_to_renumerate = [];          // store files to be renumerated
  var already_numbered_files = [];   // maintain a list of file names with existing numbers

  // populate the two arrays with relevant files or file names
  while (files_in_folder.hasNext()) {
    var current_file = files_in_folder.next();
    if (current_file.getName().match(/^\d+ -/)) {
      already_numbered_files.push(current_file.getName())
    } else {
      files_to_renumerate.push(current_file);
    }
  }

  // exit function if there are no files to renumerate
  if (files_to_renumerate.length == 0) return;
  
  // organize the files alphabetically
  files_to_renumerate.sort((a,b) => 
    a.getName().toLowerCase() > b.getName().toLowerCase() ? 1 : -1);
  
  // initialize the counter
  var counter = 0;

  // UPDATE --------------

  if (already_numbered_files.length > 0) {

    // extract all existing numbers
    var counters = already_numbered_files.map(x => x.split(' - ')[0]);

    // determine the highest number from the extracted numbers
    counter = Math.max(...counters);
  }
  
  // END UPDATE ----------

  // rename the files
  files_to_renumerate.forEach(file => file.setName(++counter + ' - ' + file.getName()));
}

Answer 2

Check out the following solution:

function renumerate_files() {
  var folder = DriveApp.getFolderById('###'); // input your folder ID here
  var files_in_folder = folder.getFiles();
  var files_to_renumerate = [];          // store files to be renumerated
  var already_numbered_files = [];   // maintain a list of file names with existing numbers

  // populate the two arrays with relevant files or file names
  while (files_in_folder.hasNext()) {
    var current_file = files_in_folder.next();
    if (current_file.getName().match(/^\d+ -/)) {
      already_numbered_files.push(current_file.getName())
    } else {
      files_to_renumerate.push(current_file);
    }
  }

  // exit function if there are no files to renumerate
  if (files_to_renumerate.length == 0) return;
  
  // organize the files alphabetically
  files_to_renumerate.sort((a,b) => 
    a.getName().toLowerCase() > b.getName().toLowerCase() ? 1 : -1);
  
  // initialize the counter
  var counter = 0;

  // UPDATE --------------

  if (already_numbered_files.length > 0) {

    // extract all existing numbers
    var counters = already_numbered_files.map(x => x.split(' - ')[0]);

    // determine the highest number from the extracted numbers
    counter = Math.max(...counters);
  }
  
  // END UPDATE ----------

  // rename the files
  files_to_renumerate.forEach(file => file.setName(++counter + ' - ' + file.getName()));
}

Prefix the file names in a folder with sequential numbers based on the highest number already used as a prefix

Answer №1

Similar questions

Loading drop-down menu content after making an AJAX request

Issue with retrieving data from MySQL database using PHP in Chart.js

Updating the Structure of Various Objects with an Object Model Schema

Why is a <script> tag placed within a <noscript> tag?

Identifying whether a child component is enclosed within a specific parent using React

Connecting a specific URL of an API to a single mobile app: A step-by-step guide

Incorporating an element into a nested array

Deceptive scope dilemma?

Invoke data-id when the ajax call is successful

What is the fastest way to efficiently refresh a substantial BufferGeometry?

Adjust the size of the Div and its content to fit the dimensions of

The zip() operator in RxJS is not functioning as intended. It consistently finishes execution without emitting any values

Customize your Shopify Messenger icon using JavaScript!

A guide on effectively utilizing nested arrays within a pcolumn prime ng data table

Are you patiently anticipating the definition of variables?

Server Crash Causes Hapi to Fail Under Request Load

An error was encountered with Ajax and JSONP due to an unexpected token causing a SyntaxError

Using ng-repeat on a select element is replacing the original content

Step-by-step guide on making a post request to the Facebook Graph Api with Httparty in a Rails application

What methods can be used to reveal the true value of data that has been encrypted?