File Rename Control - macOS vs. OneDrive

I am doing backups of the databases and one of the repositories where I have the most available space is OneDrive. Unfortunately, what is OK for the macOS file system is NOT for OneDrive. I get the following message on numerous files (and a few folders):

The name contains characters that aren’t allowed

Please rename the item, so we can sync it. For example, make sure it doesn’t begin or end with a space, end with a period, begin with two periods, or include any of these characters: \ /:*? " < > |

What’s the best approach to make sure the file names can meet the criteria? Many captures have legitimate pipe and question marks in them and a lot of those characters are hard to search for, either in Name or File Name.

Is there a way to control the file renaming, no matter what the Name is set to, or do I have to change the Name to a OneDrive acceptable naming convention?

Many captures have legitimate pipe and question marks in them and a lot of those characters are hard to search for, either in Name or File Name.

I would disagree with this assessment. Pipes and question marks are problematic and therefore I’d suggest they’re not legitimate. You should be observing the safest practices for cross-platform filenaming, e.g., no punctuation except hyphens, underscores, and dots.

Check DEVONthink’s General Preferences for a setting to use more compatible filenaming.