Posted: 7 years 7 months 18 days 9 hours 5 minutes ago
Edited: Wed, 07 Sep, 2016 at 15:56:27 (2787 days ago)
It is because TXT is being trimmed, therefore the %SUBST applies to the resulting value. For example, assume:
txt = ' HELLO WORLD';
Then you do the operation: %TRIML(TXT)
The intermediate result is 'HELLO WORLD' which has a length of 11, not 15. Then you do %SUBST(%TRIML(TXT):1:15) you are trying to extract 15 positions from a value that has only 11.To correct it, avoid specifying the last value for %SUBST (15 in your example) and allow it to default. That will extract to the end of the field or value.Having said that, your %SUBST has no value or purpose in this expression. It does nothing but introduce the potential for errors as you've discovered.
Posted: 7 years 7 months 18 days 9 hours 2 minutes ago
Edited: Wed, 07 Sep, 2016 at 16:45:50 (2787 days ago)
Thanks Bob once again!
Posted: 7 years 7 months 17 days 11 hours 11 minutes ago
TxtOut = %TrimL(Txt) ;
You only want 15 characters which is the length of TxtOut anyway. If the %TrimL returns fewer characters, no problem, TxtOut is cleared before the assignment occurs, so TxtOut would have trailing blanks.
Ringer