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

Post a reply


In an effort to prevent automatic submissions, we require that you complete the following challenge.
Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

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

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

by ZvezdanD » Mon Sep 02, 2019 10:38 am

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?
This has been already mentioned in this thread and in the Windows Defender Issue section of the add-on's web page.

Re: Shortening of artist names?

by ZvezdanD » Mon Sep 02, 2019 10:27 am

Johan_A_M wrote:
Fri Aug 23, 2019 4:38 am
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.
The extended version allows you to execute several presets at once using the Batch option. Please read the Usage section of the add-on's web page to learn more about that option.

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

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.

Shortening of artist names?

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!

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

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

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

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.

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

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!

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

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

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

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.

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

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"

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

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!!

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

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

strgVar=right(10000+ResultFromSQL,4)

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

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?

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

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

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

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

Top