can I assign blank as a variable value?

[fchu]

Great product! and I am using it all the time.
The question I have now is: how to assign (or is it possible to assign) a blank to a variable?
I've tried to use "if" command with $clipboard$ = "space", but AA prompt a message " Value Cannot be Empty". However, your FAQ mentioned that any special character can be a variable value. Any help on how to assign the special character such as "space" to a variable is appreciated.
Thanks

[forumsupport]

Hello,

To assign 'space' to a variable what you can do is create a variable of type 'Value' and set it to read value from text file. In text file, assign the value as variable=Spacebar (see image in attachment). Doing this you can assign space to variable and read the same from it.

Hope that helps.

[rlaliberte]

Along the same lines... but different.

In my quest for scheduling options, I have almost gotten to what I need... but I want to determine if a dataset that is returned from a SQL query is empty.

For instance, checking to see if today's date is stored in the database, like so:
select * from tblclosedDays where datePart(m,closedDay) = $Month$ and datepart(d,closedDay) = $Day$ and datepart(yyyy,closedDay) = $Year$

That works fine... but I need to then know did I get a resultant dataset or no results returned.

[fchu]

Thanks for the hint.
but it did not work in my case. because I am copying a blank cell in excel spread sheet and comparing with variable "Blank" (if $clipboard$ equal to $Blank$ then ....). Maybe the blank cell in excel does not mean a "space".
I m dealing with data files that insert a raw at the place that I am copying from time to time. I have to make sure to move to the next raw if I see a blank raw in a data file.
Any trick to do that?
Thanks a lot.
Fan

[archana]

In that case what you can do is, do not assign anything to variable in text file. Let us say the variable name is $Blank$ then in text file write like this like this: Blank=

The text format of command to check blank value will look something like this:

1) If $Clipboard$ Equal To $Blank$ Then
2) Message Box: "Done"
3) End If

Also, if you copy the cell in Excel using Ctrl + C then it also copies the ENTER key so it is not a blank value. To copy the content of the cell, you need to use the following key sequence

F2 + Home + Shift + End + Ctrl + c

Also I recommend you to clear the clipboard before you copy each cell.

[Vandana]

Thanks! I was searching for this and it works. Great Help.