Forum Discussion
Helper IIIsearch text not working
I need to return all characters before the "/" in driver name as a new column so i'm using the below DAX but it just errors with "The search Text provided to function 'SEARCH' could not be found in the given text." I have tried other characters and it's just not finding it. The driver name column is setup as text.
Hi Jebilaya ,
You need to add the additonal parameter of the SEARCH funcion so your SEARCH should be similar to this:
SEARCH( "/", 'Table'[Column1],1,1)Has you can see in the documentation if you ommit the last parameter it returns an error.
I have placed 1 so that when you do the -1 it does not trow an error on the left text.
Try the iferror with 1 not 0.
6 Replies
- MFelix
Super User
Hi Jebilaya ,
You need to add the additonal parameter of the SEARCH funcion so your SEARCH should be similar to this:
SEARCH( "/", 'Table'[Column1],1,1)Has you can see in the documentation if you ommit the last parameter it returns an error.
I have placed 1 so that when you do the -1 it does not trow an error on the left text.
