AnsweredAssumed Answered

Value and more problems....

Question asked by LM on Jan 12, 2010

Title

Value and more problems....

Post

Thank you to previous users, I did use Contains to find a work in a field.

I have a list of name of points (example Church Dome) and I need another field wich find if there are some words (example "church" ) in first field, and if it's real, it use the right namen for an icon (in this case the result is church.png).

 

Thanks to user raybaudi I've added this:

Let(
adj = Substitute ( nome en ; " " ; ¶ );
Case(
ValueCount ( FilterValues ( adj ; "bar" ) ) ; "bar" ;
ValueCount ( FilterValues ( adj ; "barbiere" ) ) ; "barbiere" ;
ValueCount ( FilterValues ( adj ; "cinema" ) ) ; "cinema" ;
ValueCount ( FilterValues ( adj ; "ristorante" ) ) ; "ristorante"ValueCount ( FilterValues ( adj ; "teatro" ) ) ; "teatro"

 

But this is ok for a limited number of values.

Howe to do with more words ?

It is possible than today I find a new word for the same icon, and so I need to add also this word.

Example "Dome of Milan" = "dome" = church.png 

 

Hope it's clear...

 

Thank you ,

Fabrizio




Outcomes