Dealing with Lab Reports |
There are a few different ways that lab reports can choose to structure textual data. One good technique to make it easier to deal with these different ways is to make use of Python scripting to concatenate the fragments together into a single column of a table.
One typical pattern that is commonly implemented is to represent a report with one OBX or NTE segment for each line of the report.
The other family of formats is to put the entire report in one field of an OBX segment, then use one of the following delimiters to separate the lines:
| Line Separator | Description |
|---|---|
| ~ | Repeat character |
| ^ | Sub-field separator character |
| \.br\ | Line break escape sequence |
| \n (0x0A) | Line feed character |
In each case it is very easy to write some Python code that will concatenate the strings together and output a single chunk. If you read the Python scripting chapter of this manual, examples are given of each type of transformation, including where each line of a lab result is in its own OBX segment.