Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chris100

    Extracting numbers from a text field

    Thanks Ken, I'll try this and let you know. Chris100
  2. chris100

    Extracting numbers from a text field

    Thanks Ken, Yes, that's what I need. A function that will follow the text until it finds a number. I'll try these and let you know. Thanks, Chris100
  3. chris100

    Extracting numbers from a text field

    Ken, The drug name does not contain any numbers. Just text. Thanks, Chris100
  4. chris100

    Extracting numbers from a text field

    Below is an example of a field that I need to separate. It contains the name of a drug and then the dosage. Unfortunately it is not always separated by a space or comma but it does always start with a number. Also, the name of the drug and dosage varies in length. I need to pull out the...
  5. chris100

    parse a field

    Thanks for the quick response. Chris153 - Yes the code number always starts with a C. It is also has both left and right parens around it - but is not always the same length. Yeah, it is a great name! Thanks.
  6. chris100

    parse a field

    I need help moving part of one field to another field. the Field Name is "Description". This field holds both a description and a number. Example: (ASLT Measurement (C0102992) I need to move the(C0102292)into a field of its own. Where this number appears is never the same because the...
  7. chris100

    converting time

    How do I convert time? Example 11:30 to 1130. How can it be caculated to show time spent from one point to another. Example: Patient enters the hospital at 7:00 am. Is admitted to the ICU unit at 9:00 am and goes back to the floor at 10:00 am the next day.

Part and Inventory Search

Back
Top