Fred Slota Posted June 27, 2023 Share Posted June 27, 2023 Working on modification to my Hole Finder project. Biting the bullet and adding a VBA to the Excel to include cover scans. Is there a way that I can copy ComicTitles.AlphabetizedTitle into, say, CustomField1 with a Quick Change or some such, so I can export it in an Item Checklist Report, so that I don't have to try and programmatically recreate all the text mangling rules? Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted June 27, 2023 Share Posted June 27, 2023 No. Alphabetized Title is a hidden column and is not displayed / accessible in the program (other than Advanced Find where it can be accessed with table name qualifier but still not displayed). The closest you can get is a list of Titles IN Alphabetized Title order. If you numbered them sequentially, you could use that number to get them in that order outside of CB. Link to comment Share on other sites More sharing options...
Fred Slota Posted June 27, 2023 Author Share Posted June 27, 2023 Yes, but that doesn't help with accessing the directory structure of coverscans. Oh well. Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted June 27, 2023 Share Posted June 27, 2023 You will have a problem with accessing the directory structure based on CB title names. CB titles are Unicode. Windows file structure isn't so they won't compare/match up (then there are the forbidden window file characters that are used in CB titles (like, : / ?*) Link to comment Share on other sites More sharing options...
Fred Slota Posted June 27, 2023 Author Share Posted June 27, 2023 Yes, I'm well aware. I was hoping to avoid having to do all adjustments for 0.01% improvements in cover scan reporting. Publisher directory structure differences between the big 4 and the rest I did from the start. '#' directory also implemented from the start. angled apostrophe -> flat apostrophe. strip diacriticals as I find them ':'. '/', etc. -> '-' as I find them Initial "A ", "An ", "The " move to ", A ", ", An ", ", The " in front of ":" move to ", A ", ", An ", ", The " in front of " (" move to ", A", ", An", ", The" at the end Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now