Simple conditionals and checking for spaces

[SandyDoss]

Hi,
Is there a way to check for a variable with a value of spaces in a simple condition, as in

Code: Select all

If>variable_name=" "

It looks like in the above statement the use of double quotes causes the MacroScheduler program to compare literally using the double quotes, instead of the double quotes delineating a string of spaces. Am I correct in this?

In the case of the script I'm writing now, I can change the statement to look for a value > 1, as I'm pulling in data from specific cells in a .xls sheet while looping through the rows, and I know that this particular column will have either digits or spaces. But for future reference, the check for spaces, or 'lack of data' might be useful.

As a sidebar, I also don't see anything in the manual about reserved words (other than, I'm assuming, your commands). If I'm wrong, please point me in the right direction

Thanks--Sandy

[dtaylor]

Try this to perform a match for a single space.

Code: Select all

If>variable_name=%SPACE%

OR this to match one or more spaces using a Regular Expression.

Code: Select all

RegEx>^\s+$,variable_name,0,match,num,0
If>num>0
  Remark>match found
Else
  Remark>no match found
EndIf

[Marcus Tettmar]

Or just:

Code: Select all

If>variable_name={" "}

[SandyDoss]

Thanks to all suggestions. I'll keep the use of parentheses in mind