RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

ed.j
Posts: 78
Joined: Thu May 19, 2011 1:44 pm

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by ed.j » Mon May 27, 2019 12:19 pm

Hopefully someone can give me a hand with this - I'm trying make a script that swaps A and B but only if B exists (ie B is not empty).

Swapping A and B is a preset but I'll be if I understand Reg expressions and where to put the "if B exists" part!

Can anyone give me a pointer please?

Erwin Hanzl
Posts: 265
Joined: Tue Jun 13, 2017 8:47 am
Location: Vienna

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by Erwin Hanzl » Wed May 29, 2019 12:44 pm

' A simple script that swaps the content of Title and Artist fields of selected tracks
' DEMO

Code: Select all

  Set list = SDB.SelectedSongList  
  if list.count<1 then exit sub
  For i=0 To list.count-1
    Set itm = list.Item(i)
    A = itm.Title
    B = itm.ArtistName
    if B<>"" then                   'String is Not Null And Not Empty
    	itm.Title = B
    	itm.ArtistName = A
    end if
  Next
  list.UpdateAll
:D MMW 4.1.25.1887 GOLD Beta --- Design: GLIDED 18px --- Ansicht: DETAIL
:D FindCurrentPlayingTrack 1.3.2 :D Lyrics and Comment Viewer 2.2.0.0 :D CustomFieldsTagger 1.0.3.0 :D Discogs Tagger 5.6.9
:D WIN 10 Pro-1903-64 Bit -- Windows-Defender mit Echtzeitschutz
:-? MMA 1.3.5.0853 Beta auf Huawei Mate 20 Pro
:D BILDER hochladen: https://imgbb.com/ - verwende: BBCode(Vollansicht-Link)

ed.j
Posts: 78
Joined: Thu May 19, 2011 1:44 pm

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by ed.j » Mon Jun 03, 2019 4:26 pm

Erwin Hanzl wrote:
Wed May 29, 2019 12:44 pm
' A simple script that swaps the content of Title and Artist fields of selected tracks
' DEMO

Code: Select all

  Set list = SDB.SelectedSongList  
  if list.count<1 then exit sub
  For i=0 To list.count-1
    Set itm = list.Item(i)
    A = itm.Title
    B = itm.ArtistName
    if B<>"" then                   'String is Not Null And Not Empty
    	itm.Title = B
    	itm.ArtistName = A
    end if
  Next
  list.UpdateAll
champion! thanks

cokehearth
Posts: 25
Joined: Thu Aug 24, 2017 6:13 am

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by cokehearth » Mon Jun 10, 2019 5:57 am

I'm driving myself mad trying to figure this one out.

I'm trying to set "Custom 4" field to display the TOTAL number of tracks for an entire album - and not just on the one disc.

E.g.

If Disc 1 has 10 tracks, and Disc 2 has 15, I would want to Custom 4 to display "25".

Is there any way to display this?

And optionally, to make the number be at least four numbers long? (e.g. 0025 instead of 25)?

Many thanks.

UPDATE:

I figured out getting the total number of tracks:

SQLQuery("SELECT Count(CAST(TrackNumber AS integer)) FROM Songs WHERE IDAlbum = " & oSongData.Album.ID & " GROUP BY IDAlbum")

All I need now is to find out how I ensure the result comes out as a four-figure number?

Erwin Hanzl
Posts: 265
Joined: Tue Jun 13, 2017 8:47 am
Location: Vienna

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by Erwin Hanzl » Mon Jun 10, 2019 12:30 pm

strgVar=right(10000+ResultFromSQL,4)
:D MMW 4.1.25.1887 GOLD Beta --- Design: GLIDED 18px --- Ansicht: DETAIL
:D FindCurrentPlayingTrack 1.3.2 :D Lyrics and Comment Viewer 2.2.0.0 :D CustomFieldsTagger 1.0.3.0 :D Discogs Tagger 5.6.9
:D WIN 10 Pro-1903-64 Bit -- Windows-Defender mit Echtzeitschutz
:-? MMA 1.3.5.0853 Beta auf Huawei Mate 20 Pro
:D BILDER hochladen: https://imgbb.com/ - verwende: BBCode(Vollansicht-Link)

cokehearth
Posts: 25
Joined: Thu Aug 24, 2017 6:13 am

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by cokehearth » Wed Jun 12, 2019 3:53 am

Erwin Hanzl wrote:
Mon Jun 10, 2019 12:30 pm
strgVar=right(10000+ResultFromSQL,4)
Works beautifully!

Many thanks, Erwin!!

Erwin Hanzl
Posts: 265
Joined: Tue Jun 13, 2017 8:47 am
Location: Vienna

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by Erwin Hanzl » Wed Jun 12, 2019 11:37 am

Bingo
Thanks for the feedback.
It is always nice to know if suggestions could be implemented

You could also try to build your SQL query instead of "ResultFromSQL"
:D MMW 4.1.25.1887 GOLD Beta --- Design: GLIDED 18px --- Ansicht: DETAIL
:D FindCurrentPlayingTrack 1.3.2 :D Lyrics and Comment Viewer 2.2.0.0 :D CustomFieldsTagger 1.0.3.0 :D Discogs Tagger 5.6.9
:D WIN 10 Pro-1903-64 Bit -- Windows-Defender mit Echtzeitschutz
:-? MMA 1.3.5.0853 Beta auf Huawei Mate 20 Pro
:D BILDER hochladen: https://imgbb.com/ - verwende: BBCode(Vollansicht-Link)

cokehearth
Posts: 25
Joined: Thu Aug 24, 2017 6:13 am

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by cokehearth » Wed Jul 24, 2019 5:23 am

Excuse me if this has been asked before, but I couldn't find an answer thus far.

Is it possible to use this add-on to have multiple fields copied to a single field?

For example:
Year -> Genre, Album Artist -> Genre, Grouping -> Genre

So that the resulting Genre field would display:

2000; Madonna; Album
(which is <Year>; <Album Artist>; <Grouping>)

Many thanks.

Erwin Hanzl
Posts: 265
Joined: Tue Jun 13, 2017 8:47 am
Location: Vienna

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by Erwin Hanzl » Wed Jul 24, 2019 11:14 am

Code: Select all

  Set list = SDB.SelectedSongList  
  if list.count<1 then exit sub
  For i=0 To list.count-1
    Set itm = list.Item(i)
    itm.Genre=itm.Year & "; " & itm.AlbumArtistName & "; " & itm.AlbumName
  Next
  list.UpdateAll
https://www.mediamonkey.com/wiki/index.php/SDBSongData
:D MMW 4.1.25.1887 GOLD Beta --- Design: GLIDED 18px --- Ansicht: DETAIL
:D FindCurrentPlayingTrack 1.3.2 :D Lyrics and Comment Viewer 2.2.0.0 :D CustomFieldsTagger 1.0.3.0 :D Discogs Tagger 5.6.9
:D WIN 10 Pro-1903-64 Bit -- Windows-Defender mit Echtzeitschutz
:-? MMA 1.3.5.0853 Beta auf Huawei Mate 20 Pro
:D BILDER hochladen: https://imgbb.com/ - verwende: BBCode(Vollansicht-Link)

cokehearth
Posts: 25
Joined: Thu Aug 24, 2017 6:13 am

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by cokehearth » Thu Jul 25, 2019 11:19 am

Erwin Hanzl wrote:
Wed Jul 24, 2019 11:14 am

Code: Select all

  Set list = SDB.SelectedSongList  
  if list.count<1 then exit sub
  For i=0 To list.count-1
    Set itm = list.Item(i)
    itm.Genre=itm.Year & "; " & itm.AlbumArtistName & "; " & itm.AlbumName
  Next
  list.UpdateAll
https://www.mediamonkey.com/wiki/index.php/SDBSongData
Very much appreciated, thank you!

tm806891
Posts: 1
Joined: Sat Aug 03, 2019 5:43 am

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by tm806891 » Sat Aug 03, 2019 5:57 am

I have upgraded my computer from Windows 7 to Windows 10. Now the RegExp Find & Replace app takes almost a minute (or more) just to load. Does anyone have advice on what to do about this? Perhaps I should re-install the app. If so, where is the most up-to-date version of it? Or is there something else I can do? I know that with the Windows upgrade more memory is required and so other things have slowed on the computer, but only a little bit. This one has become categorically different in terms of slowness since I upgraded. Please advise.

Erwin Hanzl
Posts: 265
Joined: Tue Jun 13, 2017 8:47 am
Location: Vienna

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by Erwin Hanzl » Mon Aug 05, 2019 8:57 am

DOWNLOAD RegExp Find and Replace Version 4.4.9: http://solair.eunet.rs/~zvezdand/RegExpReplace.htm
:D MMW 4.1.25.1887 GOLD Beta --- Design: GLIDED 18px --- Ansicht: DETAIL
:D FindCurrentPlayingTrack 1.3.2 :D Lyrics and Comment Viewer 2.2.0.0 :D CustomFieldsTagger 1.0.3.0 :D Discogs Tagger 5.6.9
:D WIN 10 Pro-1903-64 Bit -- Windows-Defender mit Echtzeitschutz
:-? MMA 1.3.5.0853 Beta auf Huawei Mate 20 Pro
:D BILDER hochladen: https://imgbb.com/ - verwende: BBCode(Vollansicht-Link)

Johan_A_M
Posts: 1
Joined: Sun Feb 19, 2017 6:01 am

Shortening of artist names?

Post by Johan_A_M » Fri Aug 23, 2019 4:38 am

Hi! I'm rather new to both MM and all kind of regex, so sorry for a maybe basic question. I'm trying to shorten names from e.g. Johann Pachelbel to J. Pachelbel. Right now, I first run a preset to insert ". " after the first letter, then I run the preset to remove 1 word after the first word.
Is there a way/preset to do all this at once? Im using the extended version.
Thanks!

Dan33185
Posts: 221
Joined: Sun Nov 08, 2009 4:36 pm
Contact:

Re: RegExp Find & Replace 4.3 w/ 253 presets (2011-07-06) [MM2+]

Post by Dan33185 » Fri Aug 23, 2019 3:07 pm

tm806891 wrote:
Sat Aug 03, 2019 5:57 am
I have upgraded my computer from Windows 7 to Windows 10. Now the RegExp Find & Replace app takes almost a minute (or more) just to load. Does anyone have advice on what to do about this? Perhaps I should re-install the app. If so, where is the most up-to-date version of it? Or is there something else I can do? I know that with the Windows upgrade more memory is required and so other things have slowed on the computer, but only a little bit. This one has become categorically different in terms of slowness since I upgraded. Please advise.
I had the same problem. What I ended up doing was deleting a bunch of the presets I never used, and it now loads much faster. Not sure if that's an option for you, but just an idea.

Post Reply