Print

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

[cncb]

I like to use nested Keywords in my photos for organization but for display I would like to just list the "childmost" part.  For example, instead of displaying "People\Our Family\Craig;People\Fred" I would like to display just "Craig;Fred".  I see the ListItem() function but don't see any way to "loop" through all the list items? 

[marko]

I've struggled with this one too, without success.

I think that what we need is an expression that will parse the field for each instance of "\...;" and return the characters inbetween.

-marko

[lise]

I've been at that for the last year, and couldn't come up with anything. I wanted to view panes with the various parents so Finishing\antiquing\glazing could be viewed as three panes: Finishing    Antiquing   Glazing
I tried looping, listing things before a bracket, nothing worked.
The only way to get what I want is by using 3 fields, which is great but more of a hassle when tagging. So much easier to just tag everything as keywords. When the day comes where we could explode the nested elements I'll be one happy camper.

[rick.ca]

It must be time for another Smartlist Smackdown...

Here's my submission. It only handles up to four terms of up to four branches each, but it works. I offer it only as a challenge for the masters to come up with something more elegant.

Code: [Select]

ListBuild(1,;,
If(IsEmpty(ListItem(ListItem([Keywords],0,;),1,\)),ListItem(ListItem([Keywords],0,;),0,\),
If(IsEmpty(ListItem(ListItem([Keywords],0,;),2,\)),ListItem(ListItem([Keywords],0,;),1,\),
If(IsEmpty(ListItem(ListItem([Keywords],0,;),3,\)),ListItem(ListItem([Keywords],0,;),2,\),
ListItem(ListItem([Keywords],0,;),3,\)))),
If(IsEmpty(ListItem(ListItem([Keywords],1,;),1,\)),ListItem(ListItem([Keywords],1,;),0,\),
If(IsEmpty(ListItem(ListItem([Keywords],1,;),2,\)),ListItem(ListItem([Keywords],1,;),1,\),
If(IsEmpty(ListItem(ListItem([Keywords],1,;),3,\)),ListItem(ListItem([Keywords],1,;),2,\),
ListItem(ListItem([Keywords],1,;),3,\)))),
If(IsEmpty(ListItem(ListItem([Keywords],2,;),1,\)),ListItem(ListItem([Keywords],2,;),0,\),
If(IsEmpty(ListItem(ListItem([Keywords],2,;),2,\)),ListItem(ListItem([Keywords],2,;),1,\),
If(IsEmpty(ListItem(ListItem([Keywords],2,;),3,\)),ListItem(ListItem([Keywords],2,;),2,\),
ListItem(ListItem([Keywords],2,;),3,\)))),
If(IsEmpty(ListItem(ListItem([Keywords],3,;),1,\)),ListItem(ListItem([Keywords],3,;),0,\),
If(IsEmpty(ListItem(ListItem([Keywords],3,;),2,\)),ListItem(ListItem([Keywords],3,;),1,\),
If(IsEmpty(ListItem(ListItem([Keywords],3,;),3,\)),ListItem(ListItem([Keywords],3,;),2,\),
ListItem(ListItem([Keywords],3,;),3,\)))))&datatype=[list]
The code includes line breaks for readability. They don't seem to impair function. And because I wouldn't believe me if I were you—a screen shot...

[Edit:] Oops. Forgot the &datatype=[li st] at the end

[cncb]

It must be time for another Smartlist Smackdown...

Thanks for that and it probably would work for me as I think I only go 3 levels deep but that is one ugly expression! 

[rick.ca]

Thanks for that and it probably would work for me as I think I only go 3 levels deep but that is one ugly expression!

It's easily modified to handle any number of terms and levels. What it lacks in beauty it makes up for in symmetry.

[marko]

That's pretty good rick, nice work there.

Gappie would really appreciate that too, does anyone know where he's got to? I've not seen him around for a while now...

-marko.

[gappie]

thank you marko for the mail... i like expressions. and i think that ricks solution is as elegant as you can get with the tools available now. nice.

there is also one simple solution with a different outcome (and something i use for places) , but some people might like that. to take cncb's example, it will add people and our family to the list, but also animals, dogs, beside ficky and brutus.
the solution is getting very simple then.

Code: [Select]

Replace([keywords],\,;)&datatype=[list]
gab

[rick.ca]

It's nice I found a solution this time, but what can I do about this evil voice in my head that keeps saying, "there must be a way to do this..."

[gappie]

It's nice I found a solution this time, but what can I do about this evil voice in my head that keeps saying, "there must be a way to do this..."

ok i bite.
would this not do the same?

Code: [Select]

ListBuild(1,;,Listitem(listitem([Keywords],0,;),math(listcount(Listitem([keywords],0,;),\)-1),\),
Listitem(listitem([Keywords],1,;),math(listcount(Listitem([keywords],1,;),\)-1),\),
Listitem(listitem([Keywords],2,;),math(listcount(Listitem([keywords],2,;),\)-1),\),
Listitem(listitem([Keywords],3,;),math(listcount(Listitem([keywords],3,;),\)-1),\))&datatype=[list]
gab

[rick.ca]

Indeed it does. Well done!

This would be a great example for the "list" section of the expressions wiki. Or maybe the "elegant" section.