0 Replies Latest reply on Jan 12, 2010 8:24 AM by LM

    Value and more problems....

    LM

      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