INTERACT FORUM

More => Old Versions => Media Center 14 (Development Ended) => Topic started by: lise on April 06, 2010, 09:15:17 pm

Title: Expression help - list 1st keyword and remove 1st character
Post by: lise on April 06, 2010, 09:15:17 pm

Basically, I need a calculated expression that says: take the first keyword and remove the 1st character.

Given the following keywords

.tools;tablesaw;jig;mitre sled   (notice that the first keyword begins with a dot)

how can I extract "tools" from this using a calculated expression?

I tried  listitem([keywords],0,;)  but that results in  .tools (notice the dot)
I need to remove the dot so that I can then use the field to create a subfolder in my renaming expression.

I tried combining the listitem expression with a Mid and a RemoveLeft, but neither worked. I can't figure out how to combine two completely different expression.

Title: Re: Expression help - list 1st keyword and remove 1st character
Post by: marko on April 07, 2010, 04:19:50 am

Quote

I can't figure out how to combine two completely different expression.

Like so: =removeleft(listitem([keywords],0),1)

(ListItem defaults to using a semi colon, so using it, while OK, is also redundant)

-marko

Title: Re: Expression help - list 1st keyword and remove 1st character
Post by: lise on April 07, 2010, 11:08:18 am

Yet again, marko to the rescue. Thanks. Worked like a charm.