How to perform mass truncate & replace on titles

[cnewtonne]

I have a need to export a long tree of items into Windows 10 NTFS drive (default). A good deal of these items have long titles. When UR exports the tree, it creates a folder fo each item and the entire filesystem path ends up exceeding the 260 character limits. As such, these rtf files fail to open with 'file not found' or 'exceeded max limit for file path'.

Furthermore, some item titles have special characters in them that are not compatible with Windows file naming convention. Causes similar issues.

I attempted different hacks to rename these files and folders, but it was just arduous.

If there a way to have UR replace item title characters and truncate them. Is this configurable anywhere? If not, can I login to the SQLite database and issue and update statement on some table? How can I get more details on what tables to update and how to login?

Thanks