INTERACT FORUM

More => Old Versions => JRiver Media Center 20 for Windows => Topic started by: mabel on May 01, 2015, 11:00:37 am

Title: POS() function - what to use instead? (Podcast downloads)
Post by: mabel on May 01, 2015, 11:00:37 am

JRiver 20.0.93

Podcast downloads.

I have set various tags in a specific order so it displays the info. I want in the correct order on my car display.

I have set all the fields as I want apart from the NAME filed.

I only want data to the right of the first colon (see below) but there is no POS function (to find out where the colon is), so I can tell the RIGHT function where to start.

Any suggestion/advice is most welcome


The name field is in the format of;

Program Name colon space Program Title

e.g.

5LI: NHS Staff Who Can't Speak English 18 SEP 11

I want to remove the Program Name Colon Space

And just leave the Program Title

e.g.

NHS Staff Who Can't Speak English 18 SEP 11


thanks

Title: Re: POS() function - what to use instead? (Podcast downloads)
Post by: Vincent Kars on May 02, 2015, 02:36:14 pm

Try ListItem([Name],1,;)

It says slit the field [Name] using ; as a separator and return the second instance

Title: Re: POS() function - what to use instead? (Podcast downloads)
Post by: mabel on May 02, 2015, 03:33:10 pm

thanks but that doen't do what i need.

although there may be a different way to achieve what i want.

a more experianced programmer may understand things better.

I want to know the position of the colon, say position 5 so i can use that (5) in the right function.

the listitem functions returns the 'item' at a sepecific position.

thanks for the suggestion

Title: Re: POS() function - what to use instead? (Podcast downloads)
Post by: Vincent Kars on May 02, 2015, 03:43:38 pm

As there is no Pos() function one has to find other ways.

Quote

I only want data to the right of the first colon

That is exactly what this list function does

Title: Re: POS() function - what to use instead? (Podcast downloads)
Post by: mabel on May 02, 2015, 04:06:51 pm

thanks

i didn't replace the semi-colon in the example you gave with a colon.

now it has a colon it returns the second item.

unfortunatly all it returns is the second item, not the complee text from the first colon to the end of the list.

e.g.

sci prog: Hr1: Smartphone HIV Test, Lost City Exploration, Mars Rover Budget

just returns Hr1

and not

Hr1: Smartphone HIV Test, Lost City Exploration, Mars Rover Budget

Title: Re: POS() function - what to use instead? (Podcast downloads)
Post by: Vincent Kars on May 02, 2015, 04:20:53 pm

Replace([Name], ListItem([Name],0,:))

Title: Re: POS() function - what to use instead? (Podcast downloads)
Post by: mabel on May 02, 2015, 04:44:58 pm

thank you

i will go and work out how that works

thanks again