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( SUM...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    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

     

haozhong's avatar
haozhong
Resolver I
9 years ago

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