thefaceman wrote:1. Finding multiple 'And' in the Artist field.
I am not sure what you mean, but you certainly could use Magic Nodes and RegExp Find & Replace add-ons for this. For example, Magic Nodes mask:
Code: Select all
Multiple 'And' in the Artist field|Filter:UpperW(<Artist>) GLOB '* AND * AND *'
RegExp preset:
Find what: ([^;]* and ){2,}
Into: Artist
Regular expression 1: checked
thefaceman wrote:2. Finding multiple 'spaces' WITHIN an ARTIST or TITLE fields.
Magic Nodes mask:
Code: Select all
Multiple 'spaces' WITHIN an ARTIST or TITLE fields|Filter:<Artist> Like '% %' OR <Title> Like '% %'
RegExp preset: "Remove multiple spaces from <Into Field>..."
thefaceman wrote:3. Finding a string that 'ENDS' with a specific character
Again, I don't understand what you mean by "a string". If you mean "Find Title ..." then:
Magic Nodes mask:
Code: Select all
Finding Title that 'ENDS' with a specific character|Filter:<Title> Like '%' || 'enter_a_specific_character_here'
RegExp preset: "Remove specified string from the end of <Into Field>..."
Don't worry because preset name is "Remove ...", just choose
Keep Matched or
Select Matched option from the RegExp Find & Replace dialog box and you would get displayed wanted tracks without their modification.
If you have questions regarding to Magic Nodes or RegExp Find & Replace add-ons it is recommended to post them in the related threads.
[quote="thefaceman"]1. Finding multiple 'And' in the Artist field.[/quote]
I am not sure what you mean, but you certainly could use Magic Nodes and RegExp Find & Replace add-ons for this. For example, Magic Nodes mask:
[code]Multiple 'And' in the Artist field|Filter:UpperW(<Artist>) GLOB '* AND * AND *'[/code]
RegExp preset:
Find what: ([^;]* and ){2,}
Into: Artist
Regular expression 1: checked
[quote="thefaceman"]2. Finding multiple 'spaces' WITHIN an ARTIST or TITLE fields.[/quote]
Magic Nodes mask:
[code]Multiple 'spaces' WITHIN an ARTIST or TITLE fields|Filter:<Artist> Like '% %' OR <Title> Like '% %'[/code]
RegExp preset: "Remove multiple spaces from <Into Field>..."
[quote="thefaceman"]3. Finding a string that 'ENDS' with a specific character[/quote]
Again, I don't understand what you mean by "a string". If you mean "Find Title ..." then:
Magic Nodes mask:
[code]Finding Title that 'ENDS' with a specific character|Filter:<Title> Like '%' || 'enter_a_specific_character_here'[/code]
RegExp preset: "Remove specified string from the end of <Into Field>..."
Don't worry because preset name is "Remove ...", just choose [i]Keep Matched[/i] or [i]Select Matched[/i] option from the RegExp Find & Replace dialog box and you would get displayed wanted tracks without their modification.
If you have questions regarding to Magic Nodes or RegExp Find & Replace add-ons it is recommended to post them in the related threads.