ComicTitles.AlphabetizedTitle

[Fred Slota]

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?

[Steven L. Dasinger]

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.

[Fred Slota]

Yes, but that doesn't help with accessing the directory structure of coverscans.

 

Oh well.

[Steven L. Dasinger]

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, : / ?*)

[Fred Slota]

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