I am looking to find a calulation that will give me all of the text after an underscore, for example:
If I have a field and the text is ORD_SHP_20120208, I would like to get all of the text after the second underscore. With this example I can use many functions such as left, right, LeftWords, etc... however, what is the first two words vary in length? Or the last section is more than one word?
So I would have
ORD_SHP_20120208 --> Result: 20120208
ORD_SHP_20120208 9384 --> Result: 20120208 9384
ORD_SHP9323_20120208 8475 --> Result: 20120208 8475
I would like to be able to use the replace function to get the last section in each record - so I am assuming I would need some sort of calculation.
Thank you in advance!