Post reply

how do i display only the 6 character from the right in ssrs

  • August 8, 2018 at 11:15 am

    #375532

    how can I get the 6th character from the right.. I only want to get and display it

  • August 8, 2018 at 11:39 am

    #2000878

    Have you tried using the "right" and "left" functions?  something like:
    LEFT(RIGHT(<string>,6),1)

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • August 8, 2018 at 11:47 am

    #2000880

    thanks .. that is what I needed

  • August 8, 2018 at 1:19 pm

    #2000901

    Just for fun, a different option.
    =Mid(<string>, Len(<string>) - 5, 1)
    Are you sure that you'll always have at least 6 characters in your string? What happens if  that doesn't happen?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply