Looking for Iguana v.5 or v.6? Learn More or see the Help Center.
Solving the Problem with Python |
To solve this problem, you need to use four scripts. The first step is to use the following code to pull apart the phone number in the PID 13 field. Then you need to assign the value to either the variable HomePhoneNumber or BusinessPhoneNumber. Note that the example below has initially assigned empty values to these variables:
import re
# We have to write this code to figure out if we have a business or a home phone number.
# The home phone is presented in the format,
# (XXX)-XXX-XXXXCHome
# and the business phone is presented in the format,
# (XXX)-XXX-XXXXCWork
# This code breaks that string apart and decides
# if the phone number is a business or a home one.
# First set these variables to be empty.
HomePhoneNumber = ""
BusinessPhoneNumber = ""
log("PID 13 = " + value)
# We split the value into two parts, before and after the C.
NumArray = re.split( "C" , value , 2)
# Now we check that we got two parts.
if len(NumArray) > 1:
PhoneNumber = NumArray[0]
PhoneType = NumArray[1]
elif len(NumArray) == 1:
PhoneNumber = NumArray[0]
PhoneType = "Home"
else:
log("No phone number present")
# If a phone number was present, i.e. len(NumArray) > 0 then,
if PhoneType == "Home":
HomePhoneNumber = PhoneNumber
log("PID -13 had the home phone number")
else:
BusinessPhoneNumber = PhoneNumber
log("PID -13 had the business phone number")
|
You will notice the use of log messages throughout the script to assist in testing. These messages can be viewed in the Debug window (View > Show Debug Output) of Chameleon.
The PID-14 script is very similar:
import re
log("PID 14 = " + value)
# We split the value into two parts, before and after the C.
NumArray = re.split( "C" , value , 2)
# Now we check that we got two parts.
if len(NumArray) > 1:
PhoneNumber = NumArray[0]
PhoneType = NumArray[1]
elif len(NumArray) == 1:
PhoneNumber = NumArray[0]
PhoneType = "Home"
else:
log("No phone number present")
# If a phone number was present, i.e. len(NumArray) > 0 then,
if PhoneType == "Home":
HomePhoneNumber = PhoneNumber
log("PID -14 had the home phone number")
else:
BusinessPhoneNumber = PhoneNumber
log("PID -14 had the business phone number")
|
The final step is to add two simple scripts to the Patient table for the Business Phone and Home Phone fields.
value = HomePhoneNumber value = BusinessPhoneNumber |