Print

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

[llafriel]

Is there a way to get all characters from right to the first open space? A sort of 'Right(value,character)', where value is the string and character is the letter where to stop.

I'd like to do Right([Composer]," "), to get the last name of the composer.

[Lasse_Lus]

with function ListItem you can do that, but it needs be a "List field" you can create a testfield, copy Composer to that field replace "space" with "semicolon"

and use the function ListItem([TESTComposer],1)

with the function Right you count and it works if you have the same number of letters all the time, but i doubt that you have

[llafriel]

with the function Right you count and it works if you have the same number of letters all the time, but i doubt that you have

Wich is why I wanted an expression that looks for the first space.
Your solution works also, but neither will work when there are more than two names.. Guess I'll have to do it manually.

[Lasse_Lus]

maybe you can involve the  ListCount(...) function and if function

[marko]

listitem can be run on any field, not just list type fields.

for the composer field, listitem( [composer],1,/ ) returns the first item from the composer field, using the space character as the specified delimiter.

To get the last item, we need to know how many items a given string has, which is not so straight forward.
I tried nesting a listcount() function within a listitem function, but this returned a syntax error

This workaround seems to work:

1. Create a new field. Give it a short name, let's say, Item. The field will be "calculated data" and the expression will be: listcount([composer],/ )
2. Enter the following expression to retrieve the last item from a space delimited composer field: listitem( [composer],[item],/ )

-marko.

[llafriel]

Thanks to both of you! Works well enough.

[hit_ny]

I tried nesting a listcount() function within a listitem function, but this returned a syntax error

What about ?

listitem([composer],[=listcount([composer],/ )],/ )

[marko]

nope, but you were on the right track...

=listitem( [composer],listcount([composer],/ ),/ )

works, without the need for any additional custom fields. Nice one hit_ny

[hit_ny]

Cool 

but still don't understand the use of '/' to imply delimiter is " "  ?

[marko]

Space characters after commas are ignored by the expression evaluator. Placing the forward slash before the space 'escapes' the space character and so the expression evaluator treats it as a part of the expression.

-marko.