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
Thanks
Scott Roth
The Ohio State University Wexner Medical Center
Discussion (3)2
Comments
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 
Thanks.
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! 