remove trailing space
Moderators: JRL, Dorian (MJT support)
remove trailing space
how do i remove trailing spaces returned from a value I am getting from an excel cell using dderequest. Is there a special character other than space that I need to use to remove these trailing spaces. Because when I tried to use blank space to remove them Macro Schedule doesn't recognize them. In the debuger these trailing spaces are displayed as kind of square zeros.
-
Lumumba
Could be that this is the equivalent to ASCII (10) --> LF aka "Line Feed"
if the variable is a digit divide it by 1
100/1 = 100
If it's a string cut it,
if the variable is a digit divide it by 1100/1 = 100
If it's a string cut it,
Code: Select all
Message>|%variable%|
Len>variable,varlength
Sub>varlength,1
MidStr>variable,1,%varlength%,variable
Message>|%variable%|