Yes! The STRIP function in Monarch V7 handles this easily:
will give you:
STRIP is designed to strip out every individual character in the target data (assume the column name is DESCRIPTION).
You will notice there is no need to specify a perfect match when you list the characters you want the STRIP function to strip out. Just list all possible characters to be stripped out, as I did above, and STRIP does the rest.
Product Marketing Manager
[size="1"][ November 18, 2003, 09:43 AM: Message edited by: Mike Urbonas ][/size]
As usual Mike's response is spot on and is an example of how V7 offers facilities for greatly simplifying the Template development process and giving elegant solutions.
For example the best I could come up with for V5 was ;-
if(IsAlpha(RSplit(SORTBY,2," ",1))=1,SORTBY,(rsplit(SORTBY,2," ",2)))
Both of these do the same thing in principle acting on a field called SORTBY.
I'm sure someone out there could offer a more elegant expression but nothing that would match using STRIP from V7.
Sometimes progress really is useful! [img]smile.gif[/img]
DEBIT MEMO 3020
I would like to exclude the numbers from these fields so that I can use a filter on this field. Any ideas for creating a calculated field that would exclude these numbers without cutting into the alpha characters? /b[/quote]