Want downloaded author metadata to go from, say, C. S. Lew to CS Lew

[chaley]

Originally Posted by droopy

Are you folks sure Regex can't automate this?

Of course it can as long as the transforms are fixed rules and not "do some random thing". theducks gave you one solution in post 9.

[droopy]

Originally Posted by theducks

Me neither stripping dot and or optional spaces

Search <<<Not tested
([A-Z])\.*\s*([A-Z])\.*\s*(.+)

Replace
\1\2 \3

Like this, Ducks?

[droopy]

It doesn't seem to work.

[chaley]

You must use "matches regex pattern".

[JSWolf]

In the two examples of C. S. Lewis and John Q. Smith, A single regex cannot fix both as they are too different. You can do regex for names that match C. S. Lewis and another regex that match John Q. Smith. Then you'd just create a new regex for any other name formats that you want to change that do not fit either of these two.

[droopy]

Originally Posted by JSWolf

In the two examples of C. S. Lewis and John Q. Smith, A single regex cannot fix both as they are too different. You can do regex for names that match C. S. Lewis and another regex that match John Q. Smith. Then you'd just create a new regex for any other name formats that you want to change that do not fit either of these two.

So what are the other regex codes/rules that I should add?

[droopy]

Originally Posted by chaley

You must use "matches regex pattern".

chaley,
i did use "matches regex pattern", didn't I? I mean, I'm comparing my screenshot with yours and it's the same. Could you run a test with your rule and tell me if it works for you? Coz it doesn't for me.

[thiago.eec]

Originally Posted by droopy

chaley,
i did use "matches regex pattern", didn't I? I mean, I'm comparing my screenshot with yours and it's the same. Could you run a test with your rule and tell me if it works for you? Coz it doesn't for me.

You first screenshot is correct. The second one, when doing the test, is different. It is not using regex.

[droopy]

Originally Posted by theducks

Me neither stripping dot and or optional spaces

Search <<<Not tested
([A-Z])\.*\s*([A-Z])\.*\s*(.+)

Replace
\1\2 \3

Hi Ducks,
your code works for
C. S. Lew --> CS Lew

But for Charles Q. Smith
it becomes
Ch arles Q. Smith
(space between h and a. And dot after Q. isn't removed).


Bob T. Johnson --> Bo b T. Johnson
Bob A. B. Johnson --> Bo b A. B. Johnson

[theducks]

Originally Posted by droopy

Hi Ducks,
your code works for
C. S. Lew --> CS Lew

But for Charles Q. Smith
it becomes
Ch arles Q. Smith
(space between h and a. And dot after Q. isn't removed).


Bob T. Johnson --> Bo b T. Johnson
Bob A. B. Johnson --> Bo b A. B. Johnson

I gave you code for C. S. Lewis ( type case), just what you asked for (I did not even try to develop a general REGEX.

Again:
Why not use the Quality Check Plugin: to detect and FIX (that is where you also set the initials pattern desired)?

I run the detect (Check Authors initials), then run Fix on the reviewed-selected results (there are some cases to NOT fix)

[droopy]

Originally Posted by theducks

I gave you code for C. S. Lewis ( type case), just what you asked for (I did not even try to develop a general REGEX.

I asked for that in the title, for sure. But in the first post, I mentioned others that I couldn't fit into title.

Originally Posted by theducks

Again:
Why not use the Quality Check Plugin: to detect and FIX (that is where you also set the initials pattern desired)?

I have done that before. But I'd rather fix it as I download metadata.

[droopy]

I discovered a problem with my peculiar standardizing of removing spaces and dots: when it searches for metadata (i.e., "Download Metadata", or Ctrl-D), it sometimes misses the books. I'm now rethinking whether I should continue doing this.