INTERACT FORUM

More => Old Versions => JRiver Media Center 19 for Windows => Topic started by: peterdrowan on October 15, 2013, 02:43:42 pm

Title: Expression column
Post by: peterdrowan on October 15, 2013, 02:43:42 pm

I have a Name field for a Podcast that usually contains the Episode number as"Episode xxx" etc. so I have created an expression field (EpisodeNumber) that extracts the number e.g Mid([name],8,3) pulls out the number but there are some Episodes that are question episodes that don't contain that Episode text so I have tried to use an IF() to only do the mid if the Name starts with Ep else return 0. I have tried many attempts at the syntax but is doesn't seem to work e.g.
If((Mid([name],0,2)=Ep),Mid([name],8,3),0). None of these work as planned.  How do I do what I want.

Peter Rowan

Title: Re: Expression column
Post by: MrC on October 15, 2013, 03:04:39 pm

if(regex([Name], /#Episode (\d+)#/), [R1], 0)

Title: Re: Expression column
Post by: peterdrowan on October 15, 2013, 03:54:31 pm

Works fine. Thanks.

Regards

Title: Re: Expression column
Post by: peterdrowan on October 15, 2013, 03:57:08 pm

I worked that out (using[Name]) just after I replied which crossed with your reply. Thanks.

Regards