DIAdem programming - How to access each cell in table data?

[NiCoder]

How do we access each cell in current access TDMS file using the DIAdem script enviroment? Would anyone send me an code example?

Thank you,

[Brad_Turpin]

Hi NiCoder,

There are several ways of doing this.  I'll answer your question after you describe what you want to accomplish with the cell values.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[NiCoder]

I have data file with 12002 rows and 35 columns and data are in hex format.  I want to loop thought each cell per each column to get bit information and decode the value into string.  For example: one cell bit 5 could be ON, OFF, or FAILED. 

[Brad_Turpin · Accepted solution]

Hi NiCoder,

If you could load those channels as numeric channels instead of string channels, then you could use the "GetB" function in the Channel Calculator to pull out a specific bit value from a numeric channel (that contains integers).  You could alternatively convert all the channels from string channels to numeric channels, then use the "GetB" function to pull out all 0 or 1 values from the 5th bit of each channel's values.  Running this command with ChnCalculate() will execute much faster than accessing each channel value one at a time, although you can use the GetB() function with each channel value in a loop.

Brad Turpin

DIAdem Product Support Engineer

National Instruments