Convert string manipulation formula from excel to CR
I have a formula that I am trying to convert to crystal syntax. In excel formula works. Basically, it outputs the string between two hyphen characters.
XXXXX-WHITE-1 >>>>>>> formula >>>>>>>> WHITE
Here is the formula that I use in excel:
How can I convert this formula into something that crystal reports understand?
P.S. A1 is going to be ItemCode.
Any help is appreciated!