Creating a AlphaNumeric Sub ID Counter (OBX.4)

Is it possible to have a, b, c, d, e, and f as a counter instead of the counter being numeric? See below...Epic would like us to set OBX.4 using a alpha numeric combination.

OBX|4|ST|69548-6^Genetic Variant Assessment|1.a|Mutation IDH1:Not Detected||||||F

OBX|5|ST|69548-6^Genetic Variant Assessment|1.b|Mutation IDH2:Not Detected||||||F

OBX|6|ST|69548-6^Genetic Variant Assessment|1.c|Mutation NPM1:Not Detected||||||F

OBX|7|ST|69548-6^Genetic Variant Assessment|1.d|Mutation RUNX1:Detected||||||F

OBX|8|ST|69548-6^Genetic Variant Assessment|1.e|Mutation TET2:Detected||||||F

OBX|9|ST|69548-6^Genetic Variant Assessment|1.f|Mutation TP53:Not Detected||||||F



Scott Roth

The Ohio State University Wexner Medical Center

  • 0
  • 0
  • 132
  • 2
  • 1


Hmm. You could do something like "1."_$C(96 + k1) for the value of that field, assuming k1 is the iterator.

Things are gonna get funky when you hit the 27th iteration, though wink

And if there will always be a fixed number of iterations, you could do "1."_$CASE(k1,1:"a",2:"b",3:"c",4:"d",5:"e",6:"f",:""). It's hard to say which solution is less intuitive, though.

Another variation ... "1."_$EXTRACT("abcdefghijklmnopqrstuvwxyz",k1).  The possibilities are endless! laugh