Extract results and text values from a memo field Crystal Reports XI 1

[davismar]

Hi!

Can anyone help me strip out some results / text values from a memo field in Crystal Reports XI?

{tvw_JournalNotes.Notes}

One result returns: Made Call: (I want to eliminate any of these results)
Second result returns: *Series...." (I want to eliminate any of these results)

I need to only display results that contain T1 or Fiber within the memo field.

Thank you, thank you for your time in advance!

 

[BobSuruncle]

Do you just want to suppress the field if it doesn't contain T1 or Fiber, or do you want to eliminate these records from being returned to the report?

If you just want to suppress the field, then you could use a formula like this:
If "T1" in {YourTable.YourMemoField} then {YourTable.YourMemoField}
else if "Fiber" in {YourTable.YourMemoField} then {YourTable.YourMemoField}

If you want the report to filter based on these values, then you'd need to modify the Record Selection Formula:
<Whatever you have now for Record Selection>
AND
(
{YourTable.YourMemoField} LIKE "*T1*"
OR
{YourTable.YourMemoField} LIKE "*Fiber*"
)

There may be more efficient ways, but this should get you started.

Bob Suruncle