Print

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

[mabel]

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

[Vincent Kars]

Try ListItem([Name],1,;)

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

[mabel]

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

[Vincent Kars]

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

I only want data to the right of the first colon

That is exactly what this list function does

[mabel]

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

[Vincent Kars]

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

[mabel]

thank you

i will go and work out how that works

thanks again