Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

CREATE TABLE mytable AS
SELECT * FROM (
    VALUES (
        array['1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532',
'P|3||QC1||^^||^^|U||||||||||||||||||||||||||',
'O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^',
'R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|',
'R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|',
'L|1|N',
'1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532',
'P|3||QC1||^^||^^|U||||||||||||||||||||||||||',
'O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)',
'R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|',
'R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|',
'R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||']
    )
) as t(myarray);

SELECT * FROM mytable
1 rows affected



myarray


{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}


SELECT
    *
FROM mytable t,
    unnest(myarray) WITH ORDINALITY as elem(value, index)


myarray
value
index


{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532
1

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
P|3||QC1||^^||^^|U||||||||||||||||||||||||||
2

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^
3

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|
4

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|
5

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
L|1|N
6

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532
7

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
P|3||QC1||^^||^^|U||||||||||||||||||||||||||
8

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)
9

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|
10

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|
11

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||
12


SELECT
    *
FROM mytable t,
    unnest(myarray) WITH ORDINALITY as elem(value, index),
    regexp_split_to_array(elem.value, '\|') as parts


myarray
value
index
parts


{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532
1
{1H,*^&,"","",Mindry^^,"","","","","","",PR,1394-97,20210225142532}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
P|3||QC1||^^||^^|U||||||||||||||||||||||||||
2
{P,3,"",QC1,"",^^,"",^^,U,"","","","","","","","","","","","","","","","","","","","","","","","","",""}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^
3
{O,3,1^Sample123^1,"","TBILV^Bilirubin Total (VOX Method)^^"}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|
4
{R,23,"KA^Bilirubin Total (VOX Method)^^F",17.648074^^^^,µmol/L,""}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|
5
{R,24,"ATU^Alanine Aminotransferase^^F",58.934098^^^^,U/L,""}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
L|1|N
6
{L,1,N}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532
7
{1H,*^&,"","",Mindry^^,"","","","","","",PR,1394-97,20210225142532}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
P|3||QC1||^^||^^|U||||||||||||||||||||||||||
8
{P,3,"",QC1,"",^^,"",^^,U,"","","","","","","","","","","","","","","","","","","","","","","","","",""}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)
9
{O,3,1^Sample456^1,"","TBILV^Bilirubin Total (VOX Method)"}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|
10
{R,23,"TBILV^Bilirubin Total (VOX Method)^^F",17.648074^^^^,""}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|
11
{R,24,"ALT^Alanine Aminotransferase^^F",58.934098^^^^,U/L,""}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||
12
{R,25,"TTU^Alkaline phosphatase^^F",92.675340^^^^,U/L,^,N,"",""}


SELECT
    *
FROM mytable t,
    unnest(myarray) WITH ORDINALITY as elem(value, index),
    regexp_split_to_array(elem.value, '\|') as parts
WHERE parts[1] IN ('R', 'O')


myarray
value
index
parts


{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^
3
{O,3,1^Sample123^1,"","TBILV^Bilirubin Total (VOX Method)^^"}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|
4
{R,23,"KA^Bilirubin Total (VOX Method)^^F",17.648074^^^^,µmol/L,""}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|
5
{R,24,"ATU^Alanine Aminotransferase^^F",58.934098^^^^,U/L,""}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)
9
{O,3,1^Sample456^1,"","TBILV^Bilirubin Total (VOX Method)"}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|
10
{R,23,"TBILV^Bilirubin Total (VOX Method)^^F",17.648074^^^^,""}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|
11
{R,24,"ALT^Alanine Aminotransferase^^F",58.934098^^^^,U/L,""}

{1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample123^1||TBILV^Bilirubin Total (VOX Method)^^","R|23|KA^Bilirubin Total (VOX Method)^^F|17.648074^^^^|µmol/L|","R|24|ATU^Alanine Aminotransferase^^F|58.934098^^^^|U/L|",L|1|N,1H|*^&|||Mindry^^|||||||PR|1394-97|20210225142532,P|3||QC1||^^||^^|U||||||||||||||||||||||||||,"O|3|1^Sample456^1||TBILV^Bilirubin Total (VOX Method)","R|23|TBILV^Bilirubin Total (VOX Method)^^F|17.648074^^^^|","R|24|ALT^Alanine Aminotransferase^^F|58.934098^^^^|U/L|","R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||"}
R|25|TTU^Alkaline phosphatase^^F|92.675340^^^^|U/L|^|N||
12
{R,25,"TTU^Alkaline phosphatase^^F",92.675340^^^^,U/L,^,N,"",""}


SELECT
    parts[1] as code,
    parts[3] as id,
    parts[4] as value,
    elem.index
FROM mytable t,
    unnest(myarray) WITH ORDINALITY as elem(value, index),
    regexp_split_to_array(elem.value, '\|') as parts
WHERE parts[1] IN ('R', 'O')


code
id
value
index


O
1^Sample123^1

3

R
KA^Bilirubin Total (VOX Method)^^F
17.648074^^^^
4

R
ATU^Alanine Aminotransferase^^F
58.934098^^^^
5

O
1^Sample456^1

9

R
TBILV^Bilirubin Total (VOX Method)^^F
17.648074^^^^
10

R
ALT^Alanine Aminotransferase^^F
58.934098^^^^
11

R
TTU^Alkaline phosphatase^^F
92.675340^^^^
12


SELECT
    parts[1] as code,
    parts[3] as id,
    parts[4] as value,
    elem.index,
    SUM((parts[1] = 'O')::int) OVER (ORDER BY elem.index) as group_id
FROM mytable t,
    unnest(myarray) WITH ORDINALITY as elem(value, index),
    regexp_split_to_array(elem.value, '\|') as parts
WHERE parts[1] IN ('R', 'O')


code
id
value
index
group_id


O
1^Sample123^1

3
1

R
KA^Bilirubin Total (VOX Method)^^F
17.648074^^^^
4
1

R
ATU^Alanine Aminotransferase^^F
58.934098^^^^
5
1

O
1^Sample456^1

9
2

R
TBILV^Bilirubin Total (VOX Method)^^F
17.648074^^^^
10
2

R
ALT^Alanine Aminotransferase^^F
58.934098^^^^
11
2

R
TTU^Alkaline phosphatase^^F
92.675340^^^^
12
2


SELECT
    *,
    first_value(id) OVER (PARTITION BY group_id ORDER BY index) as specimen_id
FROM (
    SELECT
        parts[1] as code,
        parts[3] as id,
        parts[4] as value,
        elem.index,
        SUM((parts[1] = 'O')::int) OVER (ORDER BY elem.index) as group_id
    FROM mytable t,
        unnest(myarray) WITH ORDINALITY as elem(value, index),
        regexp_split_to_array(elem.value, '\|') as parts
    WHERE parts[1] IN ('R', 'O')
) s


code
id
value
index
group_id
specimen_id


O
1^Sample123^1

3
1
1^Sample123^1

R
KA^Bilirubin Total (VOX Method)^^F
17.648074^^^^
4
1
1^Sample123^1

R
ATU^Alanine Aminotransferase^^F
58.934098^^^^
5
1
1^Sample123^1

O
1^Sample456^1

9
2
1^Sample456^1

R
TBILV^Bilirubin Total (VOX Method)^^F
17.648074^^^^
10
2
1^Sample456^1

R
ALT^Alanine Aminotransferase^^F
58.934098^^^^
11
2
1^Sample456^1

R
TTU^Alkaline phosphatase^^F
92.675340^^^^
12
2
1^Sample456^1


SELECT
    code,
    first_value(
        split_part(id, '^', 2)
    ) OVER (PARTITION BY group_id ORDER BY index) as specimen_id,
    split_part(id, '^', 1),
    split_part(value, '^', 1)
FROM (
    SELECT
        parts[1] as code,
        parts[3] as id,
        parts[4] as value,
        elem.index,
        SUM((parts[1] = 'O')::int) OVER (ORDER BY elem.index) as group_id
    FROM mytable t,
        unnest(myarray) WITH ORDINALITY as elem(value, index),
        regexp_split_to_array(elem.value, '\|') as parts
    WHERE parts[1] IN ('R', 'O')
) s


code
specimen_id
split_part
split_part


O
Sample123
1


R
Sample123
KA
17.648074

R
Sample123
ATU
58.934098

O
Sample456
1


R
Sample456
TBILV
17.648074

R
Sample456
ALT
58.934098

R
Sample456
TTU
92.675340


SELECT
    code,
    first_value(
        split_part(id, '^', 2)
    ) OVER (PARTITION BY group_id ORDER BY index) as specimen_id,
    json_build_object(
        'result_id',
        split_part(id, '^', 1),
        'result_value',
        split_part(value, '^', 1)
    ) as result
FROM (
    SELECT
        parts[1] as code,
        parts[3] as id,
        parts[4] as value,
        elem.index,
        SUM((parts[1] = 'O')::int) OVER (ORDER BY elem.index) as group_id
    FROM mytable t,
        unnest(myarray) WITH ORDINALITY as elem(value, index),
        regexp_split_to_array(elem.value, '\|') as parts
    WHERE parts[1] IN ('R', 'O')
) s


code
specimen_id
result


O
Sample123
{"result_id" : "1", "result_value" : ""}

R
Sample123
{"result_id" : "KA", "result_value" : "17.648074"}

R
Sample123
{"result_id" : "ATU", "result_value" : "58.934098"}

O
Sample456
{"result_id" : "1", "result_value" : ""}

R
Sample456
{"result_id" : "TBILV", "result_value" : "17.648074"}

R
Sample456
{"result_id" : "ALT", "result_value" : "58.934098"}

R
Sample456
{"result_id" : "TTU", "result_value" : "92.675340"}


SELECT
    *
FROM (
    SELECT
        code,
        first_value(
            split_part(id, '^', 2)
        ) OVER (PARTITION BY group_id ORDER BY index) as specimen_id,
        json_build_object(
            'result_id',
            split_part(id, '^', 1),
            'result_value',
            split_part(value, '^', 1)
        ) as result
    FROM (
        SELECT
            parts[1] as code,
            parts[3] as id,
            parts[4] as value,
            elem.index,
            SUM((parts[1] = 'O')::int) OVER (ORDER BY elem.index) as group_id
        FROM mytable t,
            unnest(myarray) WITH ORDINALITY as elem(value, index),
            regexp_split_to_array(elem.value, '\|') as parts
       WHERE parts[1] IN ('R', 'O')
    ) s
) s
WHERE code = 'R'


code
specimen_id
result


R
Sample123
{"result_id" : "KA", "result_value" : "17.648074"}

R
Sample123
{"result_id" : "ATU", "result_value" : "58.934098"}

R
Sample456
{"result_id" : "TBILV", "result_value" : "17.648074"}

R
Sample456
{"result_id" : "ALT", "result_value" : "58.934098"}

R
Sample456
{"result_id" : "TTU", "result_value" : "92.675340"}


SELECT
    specimen_id,
    json_agg(result) as test_result
FROM (
    SELECT
        code,
        first_value(
            split_part(id, '^', 2)
        ) OVER (PARTITION BY group_id ORDER BY index) as specimen_id,
        json_build_object(
            'result_id',
            split_part(id, '^', 1),
            'result_value',
            split_part(value, '^', 1)
        ) as result
    FROM (
        SELECT
            parts[1] as code,
            parts[3] as id,
            parts[4] as value,
            elem.index,
            SUM((parts[1] = 'O')::int) OVER (ORDER BY elem.index) as group_id
        FROM mytable t,
            unnest(myarray) WITH ORDINALITY as elem(value, index),
            regexp_split_to_array(elem.value, '\|') as parts
       WHERE parts[1] IN ('R', 'O')
    ) s
) s
WHERE code = 'R'
GROUP BY specimen_id


specimen_id
test_result


Sample123
[{"result_id" : "KA", "result_value" : "17.648074"}, {"result_id" : "ATU", "result_value" : "58.934098"}]

Sample456
[{"result_id" : "TBILV", "result_value" : "17.648074"}, {"result_id" : "ALT", "result_value" : "58.934098"}, {"result_id" : "TTU", "result_value" : "92.675340"}]

myarray	value	index
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	1H\|*^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532	1
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|	2
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^	3
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|	4
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|	5
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	L\|1\|N	6
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	1H\|*^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532	7
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|	8
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)	9
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|	10
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|	11
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|	12

myarray	value	index	parts
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	1H\|*^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532	1	{1H,*^&,"","",Mindry^^,"","","","","","",PR,1394-97,20210225142532}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|	2	{P,3,"",QC1,"",^^,"",^^,U,"","","","","","","","","","","","","","","","","","","","","","","","","",""}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^	3	{O,3,1^Sample123^1,"","TBILV^Bilirubin Total (VOX Method)^^"}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|	4	{R,23,"KA^Bilirubin Total (VOX Method)^^F",17.648074^^^^,µmol/L,""}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|	5	{R,24,"ATU^Alanine Aminotransferase^^F",58.934098^^^^,U/L,""}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	L\|1\|N	6	{L,1,N}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	1H\|*^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532	7	{1H,*^&,"","",Mindry^^,"","","","","","",PR,1394-97,20210225142532}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|	8	{P,3,"",QC1,"",^^,"",^^,U,"","","","","","","","","","","","","","","","","","","","","","","","","",""}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)	9	{O,3,1^Sample456^1,"","TBILV^Bilirubin Total (VOX Method)"}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|	10	{R,23,"TBILV^Bilirubin Total (VOX Method)^^F",17.648074^^^^,""}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|	11	{R,24,"ALT^Alanine Aminotransferase^^F",58.934098^^^^,U/L,""}
{1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample123^1\|\|TBILV^Bilirubin Total (VOX Method)^^","R\|23\|KA^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|µmol/L\|","R\|24\|ATU^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|",L\|1\|N,1H\|^&\|\|\|Mindry^^\|\|\|\|\|\|\|PR\|1394-97\|20210225142532,P\|3\|\|QC1\|\|^^\|\|^^\|U\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|,"O\|3\|1^Sample456^1\|\|TBILV^Bilirubin Total (VOX Method)","R\|23\|TBILV^Bilirubin Total (VOX Method)^^F\|17.648074^^^^\|","R\|24\|ALT^Alanine Aminotransferase^^F\|58.934098^^^^\|U/L\|","R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|"}	R\|25\|TTU^Alkaline phosphatase^^F\|92.675340^^^^\|U/L\|^\|N\|\|	12	{R,25,"TTU^Alkaline phosphatase^^F",92.675340^^^^,U/L,^,N,"",""}

code	id	value	index
O	1^Sample123^1		3
R	KA^Bilirubin Total (VOX Method)^^F	17.648074^^^^	4
R	ATU^Alanine Aminotransferase^^F	58.934098^^^^	5
O	1^Sample456^1		9
R	TBILV^Bilirubin Total (VOX Method)^^F	17.648074^^^^	10
R	ALT^Alanine Aminotransferase^^F	58.934098^^^^	11
R	TTU^Alkaline phosphatase^^F	92.675340^^^^	12

code	specimen_id	split_part	split_part
O	Sample123	1
R	Sample123	KA	17.648074
R	Sample123	ATU	58.934098
O	Sample456	1
R	Sample456	TBILV	17.648074
R	Sample456	ALT	58.934098
R	Sample456	TTU	92.675340

code	specimen_id	result
O	Sample123	{"result_id" : "1", "result_value" : ""}
R	Sample123	{"result_id" : "KA", "result_value" : "17.648074"}
R	Sample123	{"result_id" : "ATU", "result_value" : "58.934098"}
O	Sample456	{"result_id" : "1", "result_value" : ""}
R	Sample456	{"result_id" : "TBILV", "result_value" : "17.648074"}
R	Sample456	{"result_id" : "ALT", "result_value" : "58.934098"}
R	Sample456	{"result_id" : "TTU", "result_value" : "92.675340"}

specimen_id	test_result
Sample123	[{"result_id" : "KA", "result_value" : "17.648074"}, {"result_id" : "ATU", "result_value" : "58.934098"}]
Sample456	[{"result_id" : "TBILV", "result_value" : "17.648074"}, {"result_id" : "ALT", "result_value" : "58.934098"}, {"result_id" : "TTU", "result_value" : "92.675340"}]