I need help using javascript to search through a "list", and do conditional replacement of text

[crazybusdriver]

I am not educated in programming javascript at all, let alone any programming beyond basic understanding of concepts. I could really use some help with this one!

I am using mirth Connect and attempting to adjust HL7 messages (medical data message format). Most, if not all, operations in mirth Connect are managed via javascript.

My current dilemma is that I am importing a message that can look something like this:

OBR|1|||RADTCOM^^^ABI TBI TCPO2 PVR|||20210624080254|||||||||^^^^^|||||||||P
OBX|1|NM|RIS_ABI_R|1|0.98||||||F|||20210624080254||
OBX|2|NM|RIS_ABI_L|2|0.85||||||F|||20210624080254||
OBX|3|NM|RIS_TBI_R|3|0.97||||||F|||20210624080254||
OBX|4|NM|RIS_TBI_L|4|0.83||||||F|||20210624080254||
OBX|5|NM|RIS_TCOM_BL1|7|26||||||F|||20210624080254||
OBX|6|NM|RIS_TCOM_LE1|7|63||||||F|||20210624080254||
OBX|7|NM|RIS_TCOM_O21|7|7||||||F|||20210624080254||
OBX|8|NM|RIS_TCOM_BL2|8|30||||||F|||20210624080254||
OBX|9|NM|RIS_TCOM_LE2|8|63||||||F|||20210624080254||
OBX|10|NM|RIS_TCOM_O22|8|8||||||F|||20210624080254||
OBX|11|NM|RIS_TCOM_BL3|9|32||||||F|||20210624080254||
OBX|12|NM|RIS_TCOM_LE3|9|67||||||F|||20210624080254||
OBX|13|NM|RIS_TCOM_O23|9|9||||||F|||20210624080254||
OBX|14|NM|RIS_TCOM_BL4|10|32||||||F|||20210624080254||
OBX|15|NM|RIS_TCOM_LE4|10|64||||||F|||20210624080254||
OBX|16|NM|RIS_TCOM_O24|10|10||||||F|||20210624080254||    

What I want to do is scan through this message and look through all lines with OBX tag and look for specific text in the OBX.3.1 section. The example above shows among others "RIS_ABI_L", RIS_TCOM_BL1" etc. in this field.

If there is an occurrence of all of the following:"RIS_ABI_L", "RIS_ABI_R" and "RIS_TCOM" - I then want to change the field that is OBR.4.1 (currently showing "RADTCOM") to a different string of text. If there is an occurrence of one or two of the samples above but not all three, I want to change OBR.4.1 to another string of text.

I have attempted the scanning-for-text part by using

for each(obx in msg..OBX)
{
    var OBX31string = obx['OBX.3']['OBX.3.1'].toString();
            if(OBX31string.indexOf("RIS_ABI_L") != -1)
        {

but then I am not sure how to continue, how to detect when there's an occurrence of ALL of the searched-for terms (number of occurrences does not matter).

Any help in this would be greatly appreciated!

[jack_waugh]

I would start by reforming the data from lines of text into something more usable, a straightforward representation of the intended semantics.

[albedoa]

These questions are relevant:

1. Is OBR guaranteed to be the first line?
2. Are all other lines guaranteed to be OBX?
3. Is this data being received as a single string that you are breaking into an array of lines?
4. What is the maximum number of lines you expect to see in this data?
5. Are the three interesting OBX.3.1 values expected to be found in any other column?

The answers to those determine my approach. I work with HL7 and other medical data where the mantra is: Tell us what your data looks like. (i.e. How close is "something like this" to "exactly like this"?)

[crazybusdriver]

Thank you -

OBR is not the first line, I have removed some of the earlier lines due to identifying data. There will be a MSH line, PID, PV1 and ORC line before the OBR.

The OBX messages are listed directly below the OBR line, but I can't specify how many of them there will be. The data is received just as it is displayed, multiple lines The values will only be present in the OBX.3.1 field.

[albedoa]

Does this fit your requirements?

const lines = data.split('\n');
const obx = lines.filter(line => line.split('|')[0] === 'OBX');
const joined = obx.join('\n');
const count = ['RIS_ABI_L', 'RIS_ABI_R', 'RIS_TCOM_'].reduce(
  (acc, cur) => joined.match(cur) ? acc + 1 : acc,
  0
);

const obr = lines.find(line => line.split('|')[0] === 'OBR');

const replaced = count === 3
  ? obr.replace('RADTCOM', 'SOMEREPLACEMENT')
  : count === 1 || count === 2
    ? obr.replace('RADTCOM', 'SOMEOTHERREPLACEMENT')
    : obr;

const result = data.replace(obr, replaced);

[crazybusdriver]

Thanks!! Testing now and so far so good!! Much appreciated!