Page 65 of 109

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

Posted: Thu Jan 15, 2015 1:42 pm
by MMFrLife
You should be able to do that directly in MM.
Select all album tracks > right-click > properties > erase artist field > type in America.

Is that what you tried?
Similar "idea" for RegEx as above, but it shouldn't be necessary. It can be done as a native function.

As far as a script to just automatically do this every time, not sure, as that field's info would be unique for every album.
There is a way to lop off things at the end in RegEx. but how you would set it for the various unique lengths might be difficult.

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

Posted: Sun Jan 25, 2015 2:09 pm
by ZvezdanD
Preset: Keep only specified number of words from the end of <Into Field>...
Description: If specified value = 2, Dark Side of the Moon Pink Floyd -> Pink Floyd
Find what: .*((?:\s+\S+){<Number Caption = "Number of words" Value = "2" MaxValue="100">}$)
Into: whatever field
Regular expression 1: checked
Replace with: LTrim("$1")
VBScript: checked

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

Posted: Sun Jan 25, 2015 2:12 pm
by ZvezdanD
Preset: Remove <From Field> from the begin of <Into Field>
Description: If Album = The Wall, Artist = The Wall Pink Floyd -> Pink Floyd
Find what: ^.*
Into: whatever field (e.g. Artist)
Regular expression 1: checked
Replace with: IIf(<From Field> = Left("$&", Len(<From Field>)), LTrim(Mid("$&", Len(<From Field>) + 1)), "$&")
From: whatever field (e.g. Album)
VBScript: checked

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

Posted: Sat Mar 07, 2015 11:04 am
by Baalz
Hi!
Was looking for help with an expression to insert a "- " in a specific spot in a title
This would be within title field only and be inserted just before "01" in the following ex. "nameoftitle 01 of 13"
So I would end up with "nameoftitle - 01 of 13"
Thanks for any help
Bob

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

Posted: Wed Mar 11, 2015 9:10 pm
by MMFrLife
I want to add the track number to the end of a field. Is there a preset for this I'm blind to,
or is there a way to modify this one:

"Add Track number to the begin of Title"
I can change it to the field I want, but I don't know if there is a way (or how) to get it to the end.

.....or is there another existing preset more suitable for modification for the same purpose?

This is needed for something I do with multi-disc albums/sets.

[note: this seems related to what the previous poster is asking (something like specified string: "-" with auto-increment
to end of title (as a poss. 2nd step) and then as a 2nd or 3rd step add specified string: "of 13", maybe?]

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

Posted: Sat Mar 14, 2015 9:34 pm
by Zaphod703
Hey! Damn I Love This Program! I used to use Mediamonkey for music and now use it for organzing Audiobooks. RegExp still doing an amazing job!! I have list of all the presets in a doc in ABC order. But damn I wish I understood all the coding to create my own preset.

I tried my best to find something and really sorry if it is already possible. Basically I want to Move Text Inbetween something. Example If I use { & } in Artist category for information. And say I want to asign it to a field... or (better if possible) move it before "(" also used in field... move "{<content>}" to come before "(<contents>)". Not sure if that last one is possible? lol this stuff confuses me hahaha. Right now I can move Artist to Custom 1.... Remove everything before { and everything after }. And than move it back. Bit of work. Wondering if there is any easier way.

Sum it up:
I have Many Fields like:
"Name of Series" "(Book #)" "Book Name" "{Descriptions}" "(Year)"

Half I want to... Half Im trying to understand RegExp better... Change it to:
"Name of Series" "{Descriptions}" "(Book #)" "Book Name" "(Year)"

AND/OR... Just How to just copy everything that starts with "{" & ends with "}".

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

Posted: Wed Mar 18, 2015 2:52 am
by Friedrich
Baalz wrote:Hi!
Was looking for help with an expression to insert a "- " in a specific spot in a title
This would be within title field only and be inserted just before "01" in the following ex. "nameoftitle 01 of 13"
So I would end up with "nameoftitle - 01 of 13"
Thanks for any help
Bob
This expression in the "Find what"-Field might do the job:
(?=0[1-9])

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

Posted: Thu Mar 19, 2015 11:47 pm
by Zaphod703
I had oooone lil more question lol... I understand if my other question doesn't have an answer... This one might not either. Just curious: Is there any way to grab onto the the Last Track #. So if every album has their own track numbering.. And say one album ends at 56. At the end I want: "(of 56)" Anyway for RegExp get the Last Track # and assign it? could be assign at the end... I can already add at the end "(of" with either RegEx or ExtractFields and Also I can add the ).

Sorry if im asking bit too much!

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

Posted: Fri Mar 20, 2015 9:38 am
by Guest

Code: Select all

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

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

Posted: Mon Mar 30, 2015 4:32 pm
by redbeard
I really like this script, but am having difficulty with the "Append weighted average bitrate of album tothe last folder of path" function.
What happens, is it appends [223] even if all of the album's tracks are 320.

I looked closely and the comment says, "Example for VBScript expressions with SQLQuery (This function is somewhat problematic - SQL syntax must be correct because MM doesn't handle SQL errors)

I'm not sure what this means. I was hoping this would be an easy way to append [VBRxxx] to my album folders, with xxx being the album's average bitrate.
My question is, is this script using the bitrate in my tags? If not, what is it using? I don't know how to edit SQL. The code that is in there now is this:

"$1\$2 [" & Int(SQLQuery("SELECT Sum(Bitrate * SongLength) / Sum(SongLength) FROM Songs WHERE IDAlbum = " & oSongData.Album.ID & " GROUP BY IDAlbum") / 1000) & " kbps]\$3.$4"

Any help is greatly appreciated!
--redbeard

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

Posted: Fri Apr 03, 2015 2:40 pm
by Flanker37
Hi i have just found this thread, i have run a search, but the terms are too common for me to proper results

The problem i have, i have about 3000 tracks where the title of the songs have a single space before them. This is messing up my playlist alphabetical order.

will your plugin remove these spaces automatically, and if so, how do i go about doing it?

thanks

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

Posted: Fri Apr 03, 2015 4:06 pm
by kopo
will (the) plugin remove these spaces automatically, and if so, how do i go about doing it?
Yes it will.

Use preset 65: "Remove leading and trailing spaces from <Into Field>..."

There's a very comprehensive guide to usage in the first post of this thread.

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

Posted: Tue Apr 07, 2015 11:25 am
by rast
Cool tool thanks.
QQ: how do I remove a quote from a field? It seems I can remove anything/everything but "

thanks

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

Posted: Tue Apr 07, 2015 7:42 pm
by Hdhntr23
Let's say I import a bunch of songs where the track number is in front of the song title.

Is there a preset that allows me to move the numbers from the beginning of the song to the track number field?

Thanks!

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

Posted: Sat Apr 25, 2015 11:35 am
by MMFrLife
The new version, from what I can tell, hasn't been released yet (unless I'm just blind to it). I know your very busy, but, without having to commit to a specific
date, could you give us a ballpark ETA like "within 6 months" or "within a year"?
Thanks