Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

error in "FIND" function

Hi,

 

I'm having issues with text funciton "find".

I use it to partition string into columns (to create table with couple of additions later)

 

  

The expression is Pandl_key2 = ADDCOLUMNS( SUMMARIZE(data;[pandl]);
                                                                                      "test";FIND("-";[pandl];1)+4
                                                                                       )

 

I'm getting error "The search Text provided to function 'FIND' could not be found in the given text."

I'm sure, the "-" mark is in my text, I used same expression before on same dataset and it was working.

 

Thanks for any ideas,

Zuzana

 

 

 

 

 

  • Anonymous,

     

    Please try the expression below
    Pandl_key2 = ADDCOLUMNS( SUMMARIZE(data;[pandl]);"test";IF(ISERROR(FIND("-";[pandl];1)),BLAKN(),FIND("-";[pandl];1))+4)

     

    Regards,

    Chalrie Liao

     

3 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee

    Anonymous,

     

    Please try the expression below
    Pandl_key2 = ADDCOLUMNS( SUMMARIZE(data;[pandl]);"test";IF(ISERROR(FIND("-";[pandl];1)),BLAKN(),FIND("-";[pandl];1))+4)

     

    Regards,

    Chalrie Liao

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Charlie, 

       

      thanks for your answer.. it worked well.

      I found that there were some blank values, which probably caused this troubles. Your solution can fix this.

       

      Best regards :-)

      Zuzana

  • Are you trying to find the starting position of the "-" and then plus 4?

     

    So if it's 10-100-600331, the answer you will get is 3+4 = 7?

     

    Try this:- 

     

    Pandl_key2 = FIND("-",[pandl],1)+4

     

     

    Find Syntax is:-

     

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