Print

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

[peterdrowan]

It really annoys me that I can't seem to get the hang of using regex when it's so useful - I have read the doc!. I have a set of names that end with the artist at the end after a -.   So I should need a capture group for the - space and then all characters after that to the end of the string will go into artist.   Can someone help with the regedit needed.

Peter Rowan

[Boltron]

You can try these:

Will take the Filename and return everything after a -. It will include the -.
Regex([Filename (name)], /#(-.*)#/, 1)

This will remove the - at the beginning.
Regex([Filename (name)], /#(-.*)#/, -1)RemoveLeft([R1],1)

You can substitute Filename [Filename (name)] for [Artist] if you want to scan the artist name instead of the filename.

The basic use for regex is Regex([<WhatEverField>], /#(  <MatchSyntax>  )#/, 1)

Hope this helps.

[peterdrowan]

Worked perfectly
=if(Regex([Name], /#(-.*)#/, -1)RemoveLeft([R1],2),[Author]). Thank you.

Peter Rowan

[MrC]

Peter,

Search the forum here for regex and you'll find some examples and explanations.  Search regex, and not regedit. :-)

If you have strings of the form:

   stuff - artist

then use the following:

   Regex([Name], /#- (.+)$#/, 1)

There is no need to use RemoveLeft().  By adjusting the capture, you'll get only the portion you care about.  A point of clarification - you only need to group, both capturing and cloistering (the non-capturing form), when you want to remember a sequence, or apply other operations to a particular sequence.

[peterdrowan]

Peter,

Search the forum here for regex and you'll find some examples and explanations.  Search regex, and not regedit. :-)

If you have strings of the form:

   stuff - artist

then use the following:

   Regex([Name], /#- (.+)$#/, 1)

There is no need to use RemoveLeft().  By adjusting the capture, you'll get only the portion you care about.  A point of clarification - you only need to group, both capturing and cloistering (the non-capturing form), when you want to remember a sequence, or apply other operations to a particular sequence.

What does the (.+) do and is the fact that you have a space after the - mean it is looking for - followed by space.

Peter Rowan

[MrC]

The parens remember what is matched for later use, the dot means any character, and the + is a quantifier that means 1 or more of the previous thing.

You have it exactly right — the dash space are liberal characters that must be matched.