Hi all, I'm quite a rookie, so I beg you to be kind and to not launch me tomatoes with too energy
Starting from this (where "this" is a varchar):
|various text|other text|day: day_value|text again|
To obtain this:
day_value
Separator char is always pipe char, and the substr "day_value" I need, is always the first occurrence from the end (right) of the whole string.
Sadly, I must reach the goal using a 9i ver.
Any hint?
Best regards,
Gef.