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 » Sat Oct 12, 2019 10:34 am

lomah wrote:
Sat Oct 12, 2019 2:32 am
Can I just have some assurance that it's absolutely safe?
I don't know what kind of assurance you expect from me. I am here for more than 10 years, with more than 3000 posts, and almost 20 add-ons. For all those years nobody complained about the safety of my add-ons, excluding those reports about F-Secure that I have mentioned in the Notice section of the add-on's web page.

Besides, my add-ons could be reviewed for malicious code by anyone who knows VBScript.

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

by lomah » Sat Oct 12, 2019 2:32 am

Hi,
I have been using this excellent script for several years now. Today, I installed F-Secure SAFE suite of security apps, including "App and file control". This app has blocked the file RegExpReplace.vbs with a description:
Worm:W32/Njw0rm is a detection for maliciously modified shortcut (.LNK) files that are designed to trick users into unwittingly launching the NjW0rm file.

I think this may be a false positive, as no other AV programs have detected or blocked it. Can I just have some assurance that it's absolutely safe?

Thanks

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

by ZvezdanD » Wed Oct 09, 2019 3:24 pm

djmt99 wrote:
Wed Oct 09, 2019 11:55 am
Would this script be able to sort strings within the a field?
I would not say that it is impossible, but you will need to write a very complex VBScript.
djmt99 wrote:
Wed Oct 09, 2019 11:55 am
Also, would this script be able to add a new line for each tag within the comment field?
That would be more easily, but it depends of that how you have separated tags. For example, if you have the "; " as a tag separator, you could try to replace "; " (without quotes) with "; " & vbCrLf. VBScript expression should be turned on.

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

by djmt99 » Wed Oct 09, 2019 11:55 am

2 quick questions...

Would this script be able to sort strings within the a field? For instance, I have certain tags that I've added to them for various reasons. (The amount of tags exceed amount of custom fields, so that is not an option) Since I've added these tags at various times, I'd like to go through and sort them into alphabetical order.

Also, would this script be able to add a new line for each tag within the comment field?

Thanks!

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

Top