Creating a AlphaNumeric Sub ID Counter (OBX.4)

Question

Question

Scott Roth · Jan 24, 2018

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

Log in or sign up to continue

Jeffrey Drumm · Jan 24, 2018

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

1 0

score 0 · Answer 1 · 2018-01-24T13:36:42-05:00

Scott Roth · Jan 24, 2018

Thanks.

0 0

score 1 · Answer 2 · 2018-01-25T12:35:34-05:00

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!