• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

Crystal Report 2011

Created a report that pulls ultrasound test from providers notes.  Was able to filter by test, but the notes field is just one field with 550 text characters, I am trying to pull the ordering physician name which is imbedded in this field. The location is random, but it is always right after the string “Phys: (provider’s name).” Is there a way to pull this?  Appreciate the help. Thank you
Abe Gonzalez
Abe Gonzalez
1 Solution
It will be slow.  Will the name always be in ( )?

Are you filtering on it or do you just need to display it in the report

Formula to get the name
If there will only be 1 physician thus identified


Open in new window

To filter on it based on a user parameter

InStr("Phys:(" & {?Doctor Parameter} , {NotesFIeld})  > 0

Open in new window


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now