Forum Discussion

diederd's avatar
diederd
Icon for Helper II rankHelper II
9 years ago
Solved

Text comparison (LIKE operator)

Hello Community   I've run into a slight problem whereby I'm looking to compare a text value against a list of values in a column, however these values are separated by a ";" for each row. eg.   ...
Need Help
  • MattAllington's avatar
    MattAllington
    9 years ago

    you could use the FIND ( ) function to test if the text string is found

    FIND (find_text, within_text, [start_num], [NotFoundValue])

     

    Having said that, I think there is a very good chance that your data design is not optimal for Power Pivot.  Can you share your table data structure here?   I suspect there is a better way to pre-format your data before loading to be more efficient and effective.

diederd's avatar
diederd
Icon for Helper II rankHelper II
9 years ago

Matt,

 

Thank you for your response and suggestion regarding the issue. I'm currently looking into alternate ways in which to store the data; unfortunately this has been designed by external developers and I don't have much say in the matter.

 

Failing that, will look at perhaps some functoins in which I can confirm whether the text value exists within the text string.