The following formula field removes alphabets
StringVar MyField;
StringVar Strip;
Strip:= “”;
MyField := {Command.xxx};
While Length(MyField) > 0
Do
(
If IsNumeric(Left(MyField,1))
Then Strip := Strip + Left(MyField,1)
Else
If (Left(MyField,1)=”-”)
Then Strip := Strip + Left(MyField, 1);
MyField:= Mid(MyField,2);
);
Strip;

#1 by James Smith on March 15, 2012 - 8:17 pm
Quote
If you have a Crystal Reports with Qty and Price fields and you need an additional field in your Crystal Reports for Total, that is TOTAL = QTY X PRICE . In these types of situations you can use the Formula Field in Crystal Reports….
For more details on Formula Field in Crystal Report you may check out these links……
http://www.c-sharpcorner.com/1/61/crystal-reports-C-Sharp.aspx
http://www.mindstick.com/Articles/ad1bda11-7a4c-4760-9df3-987f46b99029/?Formula%20Field%20in%20Crystal%20Report
http://www.codeproject.com/Articles/237030/Using-Formula-in-Crystal-Report