View Single Post
  #13  
Old 06-04-2009, 09:37 AM
T-roy's Avatar
T-roy T-roy is offline
Member
SOA
 
Join Date: May 2002
College: UW Whitewater
Favorite beer: FFF GBH/NG Moon Man
Posts: 8,867
Blog Entries: 1
Default

Here is an example of what I am trying to do:

Original data:

CPT4 Description (Hypothetical)
99202 Office visit
0401 Other Drug
54015 Surgery
0110 R&B Semi Private
01100 Anethsesia

I want to split this into CPT and REV Code Like this:

CPT REV CODE DESCR
99202 ~
54015 ~
00110 ~
__________ 0401 ~
__________ 0110 ~

So all of the variables in the CPT4 from the original data are 5 digits long? How do I know if the "" is before or after the variable?
What you have to watch out for is that both rev code and cpt code could have the same substr(CPT4,1,4) (Like the R&B and Anethsesia)
__________________
Quote:
Originally Posted by ORLYLOL View Post
Beer is ****ing amazing
Reply With Quote
 
Page generated in 0.18788 seconds with 9 queries