Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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,
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
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>]])
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |