• 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
0
Abe Gonzalez
Asked:
Abe Gonzalez
1 Solution
 
mlmccCommented:
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

Split(Split({YourField},"Phys:("),")")[1]

Open in new window


To filter on it based on a user parameter

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

Open in new window


mlmcc
0

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