Today, we’ll be checking one new area where we can implement regular expression to achieve the same without involving any kind of Macro, Stored-Proc.
Many occasion we may have to parse various kind of strings. Assume that, we need to parse the string in reverse order. Until TD 14.0, you don’t have any easy method to implement the same. Off course, this new method also has some limits. It can only able to reverse couple of characters only. I have checked with 9 characters. It supports that.
So, if you have specific string lengths, then you may also try this solution if you are using TD 14.0. That will be handy.
Let’s check the Query & Output –
Hope, this will give you another way – to implement the same logic. 🙂