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.