Jump to content

Data Migration - Bulk Renaming


Dendox

Recommended Posts

We are readying to move our files to the cloud and are concerned about an issue that I am hoping the braintrust can help us with.

 

All of our equipment is Mac - including our in office server.  Mac allows naming conventions that windows will not.  one of our paralegal has saved files with back slashes for YEARS, along with other special characters.  

 

Is there an app/program/whatthefuckever that will locate replace these special characters like find-replace in word?

 

Moving 4-5 TB of data to the cloud is going to be a beating if it keeps stalling when bad file names are thrown at it.  

Link to comment
Share on other sites

In windows, I use excel to make a rename formula, apply to my files, and then run in a batch process or copy and paste into command line. I don't know macs at all, but I'd have to think something similar could be done. Or, just go with blacklab's suggestion. 

Link to comment
Share on other sites

BL's suggestion looks perfect given it has this in the freaking page.  Let me see if I can figure it out as I am far from a power user.

 

Thanks to all who have responded.

 

Quote

Power Users

AS SIMPLE AS POSSIBLE, AS COMPLEX AS NECESSARY.

 

System administrators, web masters and other power users will appreciate the presence of advanced features, such as regular expression support, conversion to Windows NTFS/SMB compatible names, the ability to import file names from a database, a spreadsheet or any other source that can produce plain or tab-delimited text files. Finally, it allows you to save a record of the current and new file names to facilitate tracking your files.

 

Link to comment
Share on other sites

Given that OSX/MacOS is unix-based, there's probably some batch files out there doing whatever you want.

Nonetheless, I think Finder will replace characters in file names pretty easily. http://osxdaily.com/2015/05/28/batch-rename-files-mac-os-x-finder/

Also this. https://manytricks.com/namemangler/

Edited by TwiceHorn
Link to comment
Share on other sites

1 hour ago, TwiceHorn said:

Given that OSX/MacOS is unix-based, there's probably some batch files out there doing whatever you want.

Nonetheless, I think Finder will replace characters in file names pretty easily. http://osxdaily.com/2015/05/28/batch-rename-files-mac-os-x-finder/

Also this. https://manytricks.com/namemangler/

If it is unix-based, I know who you need:

 

 

  • Like 1
Link to comment
Share on other sites

On 10/21/2019 at 2:29 PM, Dendox said:

Is there an app/program/whatthefuckever that will locate replace these special characters like find-replace in word?

depending upon your parameters, sed/awk/grep with a regular expression (or two) should do it. i wouldn't be surprised if someone has posted a script or one-liner to do this on stack exchange.

always use 'echo' to test your mv/cp/etc commands in your script. e.g., 'echo mv blah blah.xxx blah.xxx'

  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...