Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[mvandyke]

I updated some lyrics yesterday and found that JRiver did bring in the lyrics but also brought in a lot of other "junk".  See attached file for an example. I've seen this a lot using JRiver lookup lyrics but the <span as been at the begging of the file.

I have about 300 songs that I need to remove the bad data.  I've looked that the expressions language and did a little testing with no success.

What expression could I use to remove everything from <span to the end of the file.

Thanks
Matt

[SMU2027]

I hit rename and delete which did the trick.

[mvandyke]

I hit rename and delete which did the trick.

That removes everything from the Lyric and I would like to keep the good part of it.  I have almost 300 files that need to be touched so I would like to use an expression to clear out everything from <span to the end and keep the good part of the lyrics.

Thanks
Matt

[Matt]

What's the artist, album and name for a file pulling extra data?  We'll try to clean it up.  Thanks.

[mvandyke]

Please see attached CSV file for more details.  Sorted by Artist and then Album.

Oops CSV not allowed - here are a couple of print screens.

Although the lyrics appear OK at first glance they all have 5+ lines of "junk" in them that all start with <span.

Would still be great to know the way to remove this data (for potential future issues) with an expression.

Thanks
Matt

[zybex]

You can use

=regex([lyrics],/#(.+?)<span#/,1)

[mvandyke]

You can use

=regex([lyrics],/#(.+?)<span#/,1)

I copied that expression to a new expression field and I could not get it to work.  I tried a couple of adjustments but REGEX has always been a challenge for me.

There is always a space after <span and I tried /s but could not get it to work.

Here is a typical section of good Lyrics and then <span "Junk"

Well, you tell me men don't have much intuition
Is that what you really thinking girl
Or are you wishing
Before you wreck your old home
And search for another new
Dadgummit
Who is he, and what is he to you
Dadgummit
Who is he, and what is he to you
Dadgummit
Who is he, and what is he to you
Dadgummit
Who is he, and what is he to you
<span jsname="Bil8Ae" class="xTFaxe z1asCe SaPW2b" style="height:18px;line-height:18px;width:18px"><svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24"><path d="M12 8c1.1 0 2-.9 2-2s-.9-2-2-2-2 .9-2 2 .9 2 2 2zm0 2c-1.1 0-2 .9-2 2s.9 2 2 2 2-.9 2-2-.9-2-2-2zm0 6c-1.1 0-2 .9-2 2s.9 2 2 2 2-.9 2-2-.9-2-2-2z"></path></svg>
<span jsname="Bil8Ae" class="xTFaxe z1asCe SaPW2b" style="height:18px;line-height:18px;width:18px"><svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24"><path d="M12 8c1.1 0 2-.9 2-2s-.9-2-2-2-2 .9-2 2 .9 2 2 2zm0 2c-1.1 0-2 .9-2 2s.9 2 2 2 2-.9 2-2-.9-2-2-2zm0 6c-1.1 0-2 .9-2 2s.9 2 2 2 2-.9 2-2-.9-2-2-2z"></path></svg>
<span jsname="Bil8Ae" class="xTFaxe z1asCe SaPW2b" style="height:18px;line-height:18px;width:18px"><svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24"><path d="M12 8c1.1 0 2-.9 2-2s-.9-2-2-2-2 .9-2 2 .9 2 2 2zm0 2c-1.1 0-2 .9-2 2s.9 2 2 2 2-.9 2-2-.9-2-2-2zm0 6c-1.1 0-2 .9-2 2s.9 2 2 2 2-.9 2-2-.9-2-2-2z"></path></svg>
<span jsname="Bil8Ae" class="xTFaxe z1asCe SaPW2b" style="height:18px;line-height:18px;width:18px"><svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24"><path d="M12 8c1.1 0 2-.9 2-2s-.9-2-2-2-2 .9-2 2 .9 2 2 2zm0 2c-1.1 0-2 .9-2 2s.9 2 2 2 2-.9 2-2-.9-2-2-2zm0 6c-1.1 0-2 .9-2 2s.9 2 2 2 2-.9 2-2-.9-2-2-2z"></path></svg>
<span jsname="Bil8Ae" class="xTFaxe z1asCe SaPW2b" style="height:18px;line-height:18px;width:18px"><svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24"><path d="M12 8c1.1 0 2-.9 2-2s-.9-2-2-2-2 .9-2 2 .9 2 2 2zm0 2c-1.1 0-2 .9-2 2s.9 2 2 2 2-.9 2-2-.9-2-2-2zm0 6c-1.1 0-2 .9-2 2s.9 2 2 2 2-.9 2-2-.9-2-2-2z"></path></svg>

[Dawgincontrol]

Simplest and easiest way.

Go to "Tag".  Scroll down under "Advanced>Lyrics.  Click on the Lyric box and edit what you don't want out.  You can also fix incorrect lyrics in this manner. 

It will also let you edit in a pop-up window if you want.

[Matt]

MC28 will try to correct the issue you found.  Thank you.

[SkGe]

@ Matt
Can I add some notes about this and maybe insert a request for a way to fix some issue with fields which are large format. Ex. Comment and lyrics. I am using an program to import lyrics inside MC, when this program find the lyrics it will add to MC. As of that sometimes the lyrics have additional information which I'm trying to figure out a way to remove it. I find a way in MC to do this but I have to use multiple expression to help me removing those unnecessary text but is not quite the ideal. The other way which is tedious, is to do it manually which takes time and I will try to avoid that.
I have this example:
https://regex101.com/r/Nh4GGJ/2
Where I can use this regex method to find the text which I desire to remove but to use this in MC is not quite possible.
If I want to use it I make this expression =regex([lyrics],/#.?\[.+\]#/,0) where it tell that a lyrics has or not those texts.
How can a regex help, is a way that regex to have a replace method where he can look on the field and then remove the desire information.
regexreplace() where default 0 is to look on the first line and 1 to look on multiple lines. Change with desired information.
regexremove() the same above, with only difference is to remove the unnecessary text.
I'm not so experience with regex method and if someone has a better solution to help or to share a view jump in this chat.
Thanks

[zybex]

SkGe:
This one should work for you:

Code: [Select]

=replace(regex([Lyrics],/#(?:^|\])\x0A?([^\[]+)#/,-2),;,)
Still, a RegexReplace() would be nice, or even a ListReplace() to be used with Regex mode -2:
ListReplace(string, searchList, replacementList)

[SkGe]

@ zybex
It works partially, but now it creates multiple empty lines, and if I use trimlines() to remove that it will break the lyrics format. It will make a line of texts and no space. I will try to have a look there and see a way to keep the empty lines untouched.

[SkGe]

@ mvandyke sorry if I steal your post but maybe it can help us both

[zybex]

@SkGe, that's likely due to CRLF instead of just LF. Try this:

Code: [Select]

=trim(replace(regex([Lyrics],/#(?:^|\])[\r\n]*([^\[]+)#/,-2),;,))

[zybex]

I copied that expression to a new expression field and I could not get it to work.  I tried a couple of adjustments but REGEX has always been a challenge for me.

That's funny, it worked for me when I first tested it, but now it doesn't - this is again due to the line endings, I think.
Here's an alternative which I don't like that much, but should work:

Code: [Select]

=regex([lyrics],/#([^<]+)<span#/,1)
@Matt:
- It looks like "." doesn't match line endings. Would it break anything if you enabled the Regex SingleLine flag by default? If not, is there a way to enable it on the Regex() parameter itself? "(?s)" doesn't work.
- "((.|\r|\n)+)" should match an entire multiline string like the lyrics above, but it doesn't. Is it a bug, or am I missing something?

[mvandyke]

Thanks Zybex - that last one worked just fine!