Thanks Tom, works great. i have one question though for clarity…the string trimright you mentioned does that stop it at the space, for example when i tested:
EMERGENCY DEPT VISIT – i got EMERGENCY
THER/PROPH/DIAG INJ, IV PUSH – i got THER/PROPH/DIAG
Make sure there is no other white space in the text (such as tabs or newlines) that can cause trimright to trim unless you specify the character set you want trimmed.
I usually specify ” ” if I only want to trim spaces.
email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.
In many cases the receiving system does want to see the trailing spaces as that may mean something to them. So if tht is what you think will work best just use the string range.
However the trimright should not remove any trailing non white space characters as you appear to be experiencing.
email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.
Are you doing this in the translate? The only reason that I could see those commands doing what you are referring to would be if you were doing this on a value in the translate that was internally being treated as a list. In that case you would want to grab the value as a list so that it doesn’t split on the whitespace when accessed.
Author
Replies
Viewing 7 reply threads
The forum ‘Cloverleaf’ is closed to new topics and replies.