So this
right( orgpathtxt, CHARINDEX( '/', REVERSE( orgpathtxt ) + '/' ) + 6),
is giving me the 6 digits plus the slash and all the contents to the right.
So if the string is 'Organization/SIS/RND 434444/CIT'
It's bringing back 434444/CIT
I have found some code to find the last occurrence of it in the string, but for the life of me I can't figure out the last piece to pull the 6 digits to the left of the '/'. I'm not savvy enough, and that's why I posed this question looking for help. I always end up pulling all data to the...
I have a field-string in a table that displays like this: Organization/SIS/RND 434444/CIT
All characters could be different in all areas minus the 'Organizaiton/' part and the '/' which will always be three.
For example CIT could be 2 characters, or 3 characters or more.
What I need is to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.