WinXP
CR 10
I need to search all the names in a report to find the ones that end with either " OR" or " AND". If there are some, then I need to remove that part of the name. The I'm having problems with the fact that all the names are different lengths so how do I say, go to the end of the field and then back 3 spaces and if that text is " or" then remove it. Else go back 4 spaces and if that text is " and" then remove that!?
CR 10
I need to search all the names in a report to find the ones that end with either " OR" or " AND". If there are some, then I need to remove that part of the name. The I'm having problems with the fact that all the names are different lengths so how do I say, go to the end of the field and then back 3 spaces and if that text is " or" then remove it. Else go back 4 spaces and if that text is " and" then remove that!?