Split long report into fields of limited length |
Quite often we have long report text in a single field and have to split it to several lines shorter than the maximum field length.
In this example we can have a maximum to 80 characters in each NTE-3 field. We will split the at the last complete word not exceeding 80 characters. Then we add another NTE segment, and place the extra text in the NTE-3 field of the new segment.
 | ||
|
The "~" (tilde) character is handled as an HL7 repetition delimiter. If you prefer to preserve the tilde character as element of inline text, then ensure to properly escape it, as '\R\'. See example in test data below. | ||
 |
Here are links to the script, vmd and test data files:
Here is the sample Scripted Transformation script:
length = 80 # longest line allowed
def fix_string(s):
A = []
i = 0
while i > -1 :
next_i = s.find(' ', i + 1)
if next_i > length:
A.append(s[:i])
s = s[i:]
i = 0
else:
i = next_i
else:
A.append(s)
return A
seg = environment.input_segment_iterator()
out = seg.output()
while seg.move_one():
if seg.segment_id() != 'NTE':
out += seg.output()
if seg.segment_id() == 'NTE':
for n in range(0, seg.field(3).count_of_repeat()):
for s in fix_string(seg.field(3).repeat_field(n).value):
out += 'NTE|' + '||' + s + '\r'
# reiterate NTE segments to have sequential NTE-1 values
seg.reset(out)
out = seg.output()
j=0
while seg.move_one():
if seg.segment_id() == 'NTE':
j+=1
seg.field(1).value =str(j)
out += seg.output()
value=out |
Here is the test data, with '~' encoded as '\R\':
MSH|^~\&|||||20130926103048||ORU^R01|12345|P|2.3.1 NTE|1||Lorem ipsum dolor sit amet,\R\ consectetur adipisicing elit, ~sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. |
| ||
|
We recommend downloading the tesData.txt rather than copying the the message. The NTE-1 segment was spit into four lines for display purposes, if you copy it then change it back into a single line. | ||
|
Please send an email to support@interfaceware.com if you need more help.