txt Plugin assistant to read header date

[conzemic]

Hello

I have a text file to read with a txt-DataPlugin. It has header information which I want to read as group properties, such as

"Auftrags-Nr." "EWG038-Validation"
"Datum" "29.10.2012"
"Datum/Uhrzeit" 41211,6 ""
"Prüfer" "Storz"
"Bemerkung zur Prüfung" "EWG 038 -Eingangsmessung nach Konditionierung"
"Produktname (vollständig)" "EWG038"
"Steller Nummer" "138V"

Most of the header names and values are read in correctly. But not line 2, "date"<tab>"dd.mm.yyyy"

Step 2 of the DPA gives the following:

When ignoring the property name, I can set the value type to "Time" and string "29.10.2012" is read correctly as date 29.10.2012 0:00:0000. But I loose all the property names.

When I choose to use the first string as name, the type selctor is greyed out and the DPA insists on reading "29.10.2012" as numeric. So it reads 29.1 cutting off trailing zero and all beyond.

I tried to edit the txt-Pludin.VBS but I don't see the point where to make the script read line 2 as date.

Thank you for any clue.

Michael

[Splash]

Hello Michael,

is it possible to post the txt-file? So I can try, to import the file.

Which DIAdem-version are you using?

[conzemic]

Hello, Splash

Thank you for your offer to help

Attached please find an example:

Michael

[Lorenz-Mie]

Hi Michael,

are the quotation marks in the third line ("Datum/Uhrzeit") in the right place? Are they supposed to be behind the numeric value? Is this value the time of day in seconds?

I was able to repeat your results but have no fix for your problem. I thought about importing the file including the quotation marks (without " as "Texterkennungszeichen") and post process the data afterwards with a vsb script.

Which file do you mean by "I tried to edit the txt-Pludin.VBS"? I only found "_WizDataPluginPreview_.vbs".

Raphael

[Brad_Turpin]

Hi Michael,

Try this DataPlugin.  It seems to work for the one file you posted.

Brad Turpin

DIAdem Product Support Engineer

National Instruments