vbs character as delimiter

[joedah]

Hi,

When generating a data plugin from the Ascii import loading import the vbs generates a script with the following content

File.Formatter.Delimiters = ",""

Obviously this plugin is not working since the " character is part of the vbs script. Also i have the problem that i use two delimiters (comma [,] and ")

I think the script simply ignores the last ".

How do i solve this?

I have tried to use chr(34) in different ways...

PS! the " character is used to delimit the " in a date column looking like: "dd.mm.yyyy hh.nn.ss.fff" in a *.txt file 

Thanks in advance.

[Brad_Turpin]

Hi joedah,

In general in VBS, you would assign that character set with the following code:

File.Formatter.Delimiters = ","""

The double-double-quote inside a string constant connotes the ASCII value 34.  However, this may not work in the DataPlugin, but that depends on other details of your ASCII file.

How about if you send over an example of the ASCII file for us to take a look at?  You could also try playing around with the File.Formatter.TrimCharacters property.

Regards
Brad Turpin
Product Support Engineer
National Instruments

[joedah]

Hi Brad

I send you the ascii file. I wish to use the column marked ***(Time Stamp) as x-axis and the ***(C) column as y-axis.

The file is comma separated.

By the way, I do think that there also is a problem with the time stamp format, or?.

Kind Regards

Jørund

[joedah]

Hi Brad

I am sorry, but the attatchment dissapeared when I hit the Preview Post link.

Here it is

[Brad_Turpin]

Hi Jørund,

I went ahead and wrote a quick DataPlugin for you.  As you can see, your time stamp poses no problems for the DataPlugin api (although some do...).

Let us know if you have further questions,
Brad Turpin
DIAdem Product Support Engineer
National Instruments

[joedah]

Hi Brad

Thank you very much. THe Data Plugin worked very well. Nice to see that such plugins can be made so fast.

If you do not mind I have one more question:

-Do you know if there are any plugins for the original files from the "Agilent BenchLink Data Logger" software? I use this software on temp. measurements on a HP 34970A device. These data files contains more information such as metadata, event logs and setup information. Naturally this would be nice to have...

Kind Regards

Jørund

[AndreasH_Ha]

Hi Jørund,

so far there is no dataplugin for this file format yet. Can you provide a description for the file format ?

Andreas