Forum Discussion
search text not working
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.
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.
that was great thanks MFelix ... now stuck on my next one for the other side.
The len part of the function is producing a number when I run it on it's own but when I put it as part of the right statement I get the below error
Try the iferror with 1 not 0.
