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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics