I know this type of questions have been asked before but none solves my problem.
- I want to capture numeric parts of this string
INFORMATICS&SYSTEMS-58600i.e.58600. - I am trying to do
substr(INFORMATICS&SYSTEMS-58600,-5)which returnsATICSwhich is substr of first part of stringINFORMATICSbut I want the last part. - Wherever & is appearing this is behaving same.
I know its a very basic mistake but what ??? I cant figure out.Please help me out.