Search results for query: *

I am using CR10. I have data as follows: (fieldname.ICD10): OSRA90.23BC OSRA22.55JX I wish to convert these values to: OSRA9023BC OSRA2255JX Need help with a formula to do this.

Thanks Pete, and sorry about my very tardy response. It works

I have a “datetime” field that I wish to use to derive time difference in military hours. Perhaps datedifference is the syntax to use. An example of my data is: John Doe 2/8/2013 5:50:00 2/8/2013 8:51:00 2/9/2013 14:44:00 Sally Smith 2/9/2013 20:20:00 2/10/2013 10:05:00 2/11/2013 16:45:00 My...

Thanks. You know how all you mavens always instruct us to search on previous posts before submitting an inquiry. Well, i did that after the fact. Some previous posts by SynapseVampire and LBass helped. I stripped the text field by using the replace function and that did the trick. I was then...

Using Crystal X. I have a Memo field with a provider number displayed as '123456' I would like to make this field a number field to show as 123456 I tried to make the memo field a text field and I did. I then tried to make the new text field a number and it did not like that. I wish to strip...

A Vendor system that we use permits me to export my database to an XML file. I am not XML savvy, but I am able to then open this XML file using Excel and drag in certain fields to create some basic reports/listings. To perhaps be a bit more efficient, is there a way I might be able to connect...

[bigears]Yep that did it. Also added a -1 st the end. Thanks so much.

Totally awesome! It works. I am just trying to get rid of the the first parenthesis in the output. For example, I get the following: (Pharmacy But I can work around that. Thanks so much!

My data source is an Excel spreadsheet. I have measure names that are in a cell that also has the name of the Department in parenthesis. Example: % Cancellations Day of Surgery-PSL (Main OR) % Cancellations Day of Surgery-PSL (Perioperative Services) % Change in Overall Pain Score Intensity...

Wow. Timely and right on. Very much appreciated :) Thanks.

I am using CR10. I have a string field named {ExactDateTime} It reperesents the date and time a medication was administered. It is 16 characters in length Example: 2010100815163000 The first four characters represent year Characters 5 and 6 are month Characters 7 and 8 are day number...

I receive a list of about 1000 indivudals/month and an individual may fall into one or multiple populations (e.g., let's call the populations ABC and DEF and GHI and JKL). I need to provide a consilidated list of these individuals so that the individuals are not listed multiple times. That is...

Perfect LB. Works like a charm !!! Much appreciated.

There may be muliple procedures on a surgical case. "Procedure Dsecription" is the procedure name. There is another field named "Procedure Number" which corresponds to the Procedure Description Procedure1, Procedure2). I don't need that number, but it may be of value if it helps in creating a...

I hope this is not inappropriate to post in this forum. Our hospital needs to develop an XML file that we upload to our core measures Vendor. We do not have the expertise inhouse to do this. I am looking for a resource to do this project. So, my question is - does anyone have any suggestions...

I need my report to identify whether there exists a fracture ICD9 code. I need to check in 7 different diagnosis fields for this. The fracture code is 800.xx – 829.xx. For example, it could be coded as 801.0 or 816.9 or 829.4, etc. Would someone confirm for me whether the “in” statement I am...

Thanks everyone for the helpful feedback. Several ways to skin a cat. As a first solution, I am going to build a cipher table and do a lookup as suggested by GRUUUU. Thank you Skip,JGES and StrongM for you solutions - they seem like they would work as well.

Using a formula (see below) identified in the Crystal Reports section of this site, I used that cipher to disguise surgeon name when I upload data to an outside vendor. Later on, I am able to download all the data sent to the vendor and save it in a CSV for subsequent review. However, now I...

Access did the trick....tools, documentation. Thanks much, I did not know of that capability.

I will check that, since as you said, that is the source. Thanks.