Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RIGHT, SEARCH, LEN only providing partial string outputs

Good day,    I've searched the forums and the web and I'm hitting a wall with something which seems so straight forward, or I'm missing something.   The image below contains the DAX formula, the ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    Anonymous 

    please try this

    Column = 
if(SEARCH(":",'Table'[TEXT],1,0)=0,'Table'[TEXT],right('Table'[TEXT],len('Table'[TEXT])-SEARCH(":",'Table'[TEXT],1)))

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

Anonymous 

please try this

Column = 
if(SEARCH(":",'Table'[TEXT],1,0)=0,'Table'[TEXT],right('Table'[TEXT],len('Table'[TEXT])-SEARCH(":",'Table'[TEXT],1)))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

That did the trick - thanks for your prompt responses ryan_mayu !