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

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

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?

Re: Clean Up Song Title Information

by bebizzy » Tue Nov 27, 2018 8:15 pm

Found it! Preset 122/253 - Remove the end of <Into Field> after (and including) "-" or " - "...

I removed the "-" option and it cleared up what I needed.

Re: Clean Up Song Title Information

by bebizzy » Tue Nov 27, 2018 8:06 pm

I have that installed and thought I could make it work, but can't figure out how to do wilcards since there are a huge number of combinations of keys and energy values.

Do you know which preset and/or how to put wildcard values in for the XX values in this string? " - XX - XX"

Re: Clean Up Song Title Information

by Lowlander » Tue Nov 27, 2018 11:13 am

Clean Up Song Title Information

by bebizzy » Tue Nov 27, 2018 10:36 am

I have several Titles that contain information at the end I'd like to remove. A DJ program added the key and energy level to the end of the song titles, so they look something like this " 5-1-5-0 - 11A - 7".

What's the easiest way to remove the " - 11A - 7" from the song title without manually having to do it. Keep in minde both the key and energy number will change.

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

by popsmike » Mon Sep 24, 2018 3:27 pm

Darryl_Gittins wrote:
Sun Sep 23, 2018 5:22 pm
I did donate once but can't find the record. How do I donate again?
Head on over to his website and you can donate from there.

http://solair.eunet.rs/~zvezdand/RegExpReplace.htm

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

by Darryl_Gittins » Sun Sep 23, 2018 5:22 pm

I did donate once but can't find the record. How do I donate again?

Re: with regexpreplace.vbs installed, MMW takes a long time to start.

by ZvezdanD » Sat Sep 22, 2018 8:38 am

Darryl_Gittins wrote:
Fri Sep 21, 2018 12:27 pm
I find that with the regexpreplace.vbs script installed, MMW takes a long time (2 minutes) to start.
...
Is there a way to fix this?
That is the issue which manifested after the Windows 10 April Update. It is reported to Microsoft, but they don't care about it. You could do the next things:
- go to https://answers.microsoft.com/en-us/pro ... 29&lc=1033 and leave your report; there is a better chance that the folks in Microsoft will do something about the problem if more people request that; or
- turn off the Windows Defender Real-Time Protection and use some another anti-malware; or
- remove all RFR presets that you are not using since this slow down is related to the number of installed presets; or
- donate to me and you will get the enhanced version of the add-on which has implemented a workaround for this problem, making it as fast as before the mentioned Windows Update.

I am sorry, but currently I don't have time to implement the same workaround in the freely available version.

with regexpreplace.vbs installed, MMW takes a long time to start.

by Darryl_Gittins » Fri Sep 21, 2018 12:27 pm

I find that with the regexpreplace.vbs script installed, MMW takes a long time (2 minutes) to start. In the notification bar, I see "Loading regexpreplace.vbs"
I want to keepregexpreplace, but I'm not the most patient person.

Is there a way to fix this?

Thanks.

Top