AnsweredAssumed Answered

Searching text strings in reverse?

Question asked by rothdavid on Jul 23, 2018
Latest reply on Jul 24, 2018 by rothdavid

I recall that somewhere, I read that I can use the RIGHT() fn to search a text string from end to beginning (right to left)  I can't seem to create a calc that would do that.

 

Im using Position() to locate a # sign that is towards the end of a text string.  I want to then find the first " " (space)  that preceeds it in the string so I can parse that information out of the string.

 

Was I dreaming ?

 

Thanks for any assistance you can shed on this.

 

David

Outcomes