HI

I have a situation where I need to extract text from string which ends with delimiters.

Here is an example

e.g. Text &BIC&

the text is of different length in every row and same is with BIC. I want to extract the Text and eliminate the BIC from the field. Please can anyone suggest a formula for this in Crystal Reports 11

Also, if you need just a part of the string without the delimiters, you can use Split(<string field>, <delimiter>) to split it into an array and then walk through the array to get the pieces that you need.

-Dell