Forum Discussion
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-msftMicrosoft 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
- AnonymousNot 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
- haozhongResolver I
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>]])