Im currently using Crystal reports 9, and was wondering if it was possible to create a formula field which filters a certain word from a string read in through a text file.  For example, im creating a reminder letter which displays the customers name at the top of it, but this sometimes starts with the text FAO, I still want this to appear there, but I want to use the same field for the "Dear customer Name" part of the letter without the FAO part showing.  I.e,

 

Top of letter would be:

 

FAO Mr peter smith - accountsletter1_txt.companyname (string)

address 1 

 

The FAO does not always appear within the customer name field.  So I just want to try and say:

 

IF accountsletter1_txt.companyname BEGINS 'FAO' - then display it after that.

ELSE

accountsletter1_txt.companyname.

 

I basically just dont want anything to appear there if the FAO part of the text is present.  Is that possible?

 

Thanks again for your help.

 

Kev