Jump to content
Macro Express Forums

Excel data use


Recommended Posts

I am loading data created in Excel. Cells within any given roll can be blank. The excel file is saved as type CSV (comma delimited) (*.csv)

I created an If Variable %T[13]% equals ""

I created an If Variable %T[13]% equals " "

The program still thinks the variable has a value.

Any suggestion (other than using at tab delimited file

Thanks for you help

 

 

 

Link to comment
Share on other sites

Sample file attached.

My command is as follows:

File Name: Ven Upload

File Format: Comma Delimited Text (.csv)

Variable array %T%

 

If Variable

Variable %T[6]%

Equals

""

Or " "

 

If you look at the .csv file in notepad you will see ,,,, No date exist (I tried that command as well with no result) Macro Express thinks there is data in the blank field.

File attached.

Any suggestions?

 

 

 

Sample CSV Upload.csv

Link to comment
Share on other sites

When you enter the command
IF VARIABLE %T[n]% =
you must NOT type the double-quotes in the value (comparison) field.
That is, to compare to an empty field, you type nothing at all in the value field.  You do not type “”.
Similarly, to compare to a single blank, you type a space in the value field, you do not type “ “.  
At least that’s the way it works in ME version 3.  
Can’t tell if that is your error or not, from what I can see in your message.
The file processes as you want it to on my machine – that is, field 7 is empty on most lines as far as ME is concerned.

//  
ASCII File Begin Process: "test.csv" (Comma Delimited Text )
  Text Box Display: %T1%,%T2%,%T3%,%T4%,%T5%,%T6%,%T7%,%T8%,%T9%,%T10%,%T11%,%T12%,%T13%,%T14%,%T15%,%T16%,%T17%,%T18%
  If Variable %T7% = ""
    OR
  If Variable %T7% = " "
  Else
    Text Box Display: T7 contains data
  End If
ASCII File End Process
//  

 

Link to comment
Share on other sites

  • 4 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...