Adding a letter in front of OrderNum

[Kevin Crist]

I am wanting to add a Letter that corresponds to the type of order infront of the order number. So if it is a lab order then i would have L1234567 or if it is an Xray order then X1234567. I will have a table so i will know what letter to put thier i am just unsure of how to go about getting it their. Also, the order number is not a fixed amount of numbers, they can vary.

thanks for any insight.

Topic

[Jim Kosloskey]

If in Xlate try the CONCAT Action

Let’s sa y@letter is a temp variable where you place the letter (further let’s say the table lookup returns null if not found – more about that later).

Say the field you want to add the letter to is …OBX.#5… (obviously this is made up).

The CONCAT would have:

Source:

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Author]

Replies