AnsweredAssumed Answered

removing single character?

Question asked by bookalaka_1 on Jul 5, 2010
Latest reply on Jul 5, 2010 by bookalaka_1


removing single character?



I am having trouble figuring how to eliminate one character from account codes. Some of the codes I receive from my clients include "-" character that I need to extract. an example I receive TRN-100-10-07 what I need to use for my reports is TRN1001007. How can I eliminate the"-"??  some codes include the "-" others may have a space such as TRN 100 10 07 the space i need to eliminate also.

Thank you for your help,