Use Replace Field contents on a copy of your file with the calculation option:
Right ( YourField ; Length ( YourField ) - 1 ) & "-REP"
Thanks. However, I forgot to let you know a small detail. The part numbers in this field are not all the same length. It varies alot. However, I still want to do the same thing. remove the "Y" at the beiginning and add the "-REP" at the end of each part number in the found set.
Anyone who knows how to do this......please let me know. Thanks. Randy
My suggestion should work with variable length strings. That's why it uses the Length function.
I just tried it and cannot get it to work.
Here's what I have:
Right(partnumber); Length (partnumber)-1 & "-REP"
what am I doing wrong? Thanks. Randy
Right ( partnumber; Length ( partnumber) - 1 ) & "-REP"
it worked!!!! Thanks.
Now, what exactly, was I doing wrong? was it a spacing issue or the two parens?
The parenthesis. What you posted would immediately trigger a syntax error as the Right Function needs two parameters, the text and the number of characters, not 1.
Thanks. You helped me solve something I've wanted done for quite a while.