I am trying to find the LAST instance of a substring within a string. In Pervasive Data Integrator, I used the function "InStrRev" which exists alongside "InStr" which finds the first location of a substring within a string. Is there an equivalent way to do this in Centerprise?
I have a dataset with first name and middle initial and I would like to split out the first name and middle initial.
For instance,
With "LAUREN R", the function would need to find the space between "LAUREN" and "R"
And likewise with "BILLY BOB S", the function would need to see the space between "BOB" and "S", not between "BILLY" and "BOB"