Fred Slota Posted February 21, 2023 Share Posted February 21, 2023 Noticed on "House of Secrets (2nd series)" probably all over the place. Also, I have now realized that I don't know how to do an advanced find that is case sensitive. Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted February 21, 2023 Share Posted February 21, 2023 The following seems to respect the case of the search. It at least works to find ' series)'. Not sure how easy/difficult it is to alter it for general use in Case Sensitive finds. INSTR(I.Title, ' series)') > 0 Returns 1,572 rows INSTR(I.Title, ' Series)') > 0 Returns 122,658 rows INSTR searches the first parameter (I.Title in this example) for the second parameter (' series)' ) and returns either 0 if not found or the number of its position in the first parameter. Not sure why it works but it appears to. Link to comment Share on other sites More sharing options...
Fred Slota Posted February 22, 2023 Author Share Posted February 22, 2023 Thanks. Link to comment Share on other sites More sharing options...
Fred Slota Posted March 3, 2023 Author Share Posted March 3, 2023 Well.... On the plus side, "House of Secrets (2nd Series)" has capitalized Series on the Title title now. Thanks. On the minus side, I searched for INSTR(I.Title, ' series') > 0 and found 1,761 rows (issues, not titles) where you had found 1,572, so it went up... On the, minus side?, several of those I found were "House of Secrets (2nd series)", showing that the search was for the more hidden duplicated issue-by-issue title field and not the primary one-per-title Title field. Searched for INSTR(ComicTitles.Title, ' series') > 0 and found 480 returns. Astonishing Spider-Man, The (3rd series) Astonishing Spider-Man, The (4th series) Atom-Age Combat (2nd series) Attack (1st series) Attack (2nd series) Batgirl (3rd series) Don Winslow of the Navy (1st series) Empty Love Stories (2nd series) Empty Zone (2nd series) Fantastic Four (Juniorpress, 2nd series) Fear Diaries (2nd series) Felix the Cat (1st series) Felix the Cat (2nd series) Giant Size Spider-Man (2nd series) Giant Size Spider-Man (3rd series) House of Java (2nd series) Hugo (3rd series) Joe Palooka (1st series) Juan Centella (2nd series) Juggernaut, The (2nd series) Katy Keene (1st series) Little Lizzie (2nd series) Maxwell Mouse Follies (2nd series) Superman in the Fifties (2nd series) Terror, Inc. (2nd series) Universo DC (1st series) Universo DC (2nd series) Universo DC (3rd series) Western Gunfighters (1st series) Link to comment Share on other sites More sharing options...
Fred Slota Posted March 12, 2023 Author Share Posted March 12, 2023 Still found 480 returns, so it looks like no changes made to these titles yet 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