Print

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

[timwtheov]

Hi all,

I'm trying create an expression, probably for a calculated field, that will a) count the number of characters in a string of varying length up to a colon or a number (depending on the string) and then b) something like a "RemoveLeft()" of all those characters to the left of the colon or number. I would just do this manually with "Find and Replace," but I have a lot of different strings (in [Name]) to alter. I was thinking I'd probably need some kind of Count + a Regex (the latter to find the colon or number), all nested within a RemoveLeft. I'm just not sure how to make it stop at the colon or number. Here's a more specific example:

[Name] field currently:

String Quartet No. 3 in D Major, Op. 18 No. 3: IV. Presto

I want to remove everything to the left of "IV." so that I'm left with only

IV. Presto

because I want to substitute what came from the auto metadata lookup with the "Work Name" I use for each classical work, i.e.,

String Quartet No. 3 in D major, Op. 18/3: IV. Presto

just so everything is standardized (I know, I'm anal).


Any suggestions from Ferday or Blgentry?

Thanks!

[RD James]

Code: [Select]

ListItem([Name], 1, :)
https://wiki.jriver.com/index.php/Function_Index#ListItem

[timwtheov]

Wow! Thanks! Worked perfectly! Didn't even notice this function in there!