Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Convert string manipulation formula from excel to CR

Hello everyone,

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!

Former Member

Hi Korhan,

Try this please:

local stringvar s := {A1};

local stringvar temp := Mid(s,Instr(s,'-')+1);

if instr(temp,'-') > 0 then



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question