Alternatives to SUBSTRING and CHARINDEX?
I can t use SUBSTRING nor CHARINDEX within SSRS 2005 expression so how can i retrieve all the characters after '\' without the use of these expression?
My dataset looks like this...
msd\avf
msd\sddg
msd\sdab
msd\asdw
msd\fbf
the result should return the following
avf
sddg
sdab
asdw
fbf
May 4th, 2011 11:11am
hey there, this expression should work:
=mid("msd\fbf",InStr("msd\fbf", "\")+1)
and ofcourse you replace this literal string "msd\fbf" with whatever your field you are using
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2011 11:26am