extract text at end of field
Posted on 2013-11-26
How would I use the left + len + InStrRev functions to start at the end of the field and find "$bill" and then return that text pluss the remaining string? I know how to use the right function to bring back the last few characters, but the issue is that the string after "$bill" varies. so I want to pull "$bill" and everything after that.
It would also be nice to have it return something like "***" if the remaining string was longer than X characters (ie 10 characters), as a way to indicate that the "$bill" code was entered wrong....this would tell me that either the person entered too many characters after "$bill". Alternate suggestions/approaches are welcome.
i.e. - the memo field would contain a string similar to below:
90 day EWP
five year, to be billed biennial. maturity date 11/13/18