I'm trying to extract a substring dynamically from the right of a character.
string<- adcde?7890 desired substring: 7890
in order to achieve this I want to be able to determine the position of the "?" within each character string, where in this example the "?" would be the 6th character.
In the end my code would look something like this:
substr("location of'?'"+1 , str_length(string))
I just need a function which will show the position of the "?" within my string.