Regex Help

[BS_THE_ANALYST]

Film data:

Marvel Comics Presents (1988) #125

Spider-Man Legends Vol. II: Todd Mcfarlane Book I (Trade Paperback)

Spider-Man Legends Vol. II: Todd Mcfarlane Book I

Spider-Man Legends Vol. II: Todd Mcfarlane Book I (1998)

Marvel Comics Presents #125

Expected output:

I can see how to group it, but can't seem the REGEX it 😂..

Thanks in advance!

[binu_acs · Accepted solution]

@BS_THE_ANALYST One way of doing this with the Regex Tokenize method

[BS_THE_ANALYST]

Thanks @binu_acs . I rarely use the Tokenize method! 

Do you know if it's possible to do this with the Parse method?

[BS_THE_ANALYST · Accepted solution]

@binu_acs Parse method 

^(.*?)(?:\((\d{4})\))?(\s+#\d+)?$

[binu_acs]

@BS_THE_ANALYST That is nice, I was scratching my head 😀

[binu_acs]

@BS_THE_ANALYST you can also mark your solution.