Reply To: how to keep spaces between values in results on obx field

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf how to keep spaces between values in results on obx field Reply To: how to keep spaces between values in results on obx field

#59022
Jim Kosloskey
Participant

    Nancy,

    Maybe I am not clearly understanding your need but I think a CONCAT will do the trick.

    As I understand it you have two fields: OBX-5 (which might contain the value AMIKACIN) and OBX-? (the abnormal flag – let’s say it has a value of Y). Then betweem these two fields you want some finite number of spaces (let’s say 2).

    So you want a resulting OBX-5 field to have ‘AMIKACIN  Y’.

    A CONCAT with this in the Source list substitute the correct address path for the OBX references:

    OBX-5

    =  <--there are two spaces here OBX-?    <--- this is the abnormal flag field. The destinatiom would be OBX-5. I don’t think there is any need for Tcl – unless you need a variable rather than fixed number of spaces. I tested this on CL5.2 Patch2 and it worked fine. Jim Kosloskey

    email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.