how does diadem interpret hex values in a .csv file

[faustina]

If I have a .csv file with hex values such as 0x1111 verses 0xffff when I import it using the dataplugin?

[HeroOfHyrule]

Hello Faustina, 

DIAdem is using a dataplugin each time it is reading in data that is not in the TDMS file format. Under Options>>DataPlugins you can see a list of the plugins on the machine and can access the scripts used to read in the data. 

Regards,

[faustina]

I understand that.  When I use the DIAdem .csv plugin and the text data are hex values such as 0x1111 verses 0xffff does DIAdem properly convert the values to decimal or do they remain text?

[HeroOfHyrule]

Hi Faustina,

The Dataplugin will read the data in as Text if you have it pull that data into a String Channel. From there you would need to use VBScript to change the text values into numeric values. If you try and read the .csv into a numeric channel you will probably just get "NoValue" for each of the data points.

The VBScript command you would use should look something like this:

HexString = "100A000F"
HexInteger = CLng("&h" & HexString)

Regards,

Rob S