Print

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

[lise]

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.

[marko]

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

[lise]

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