error in "FIND" function

[Anonymous]

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

[v-caliao-msft · Accepted solution]

@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]

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

[haozhong]

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>]])