Parser to Excel problems..

[skyleet]

hi,

I have a problem whit the parser.
i writed a uc program that sense a value and sent it to te pc, de following string come's directly form the uc:

a0684#0D
a0684#0D
a0682#0D
a0682#0D
a0682#0D
a0682#0D
a0682#0D
a0682#0D
a0682#0D
a0682#0D
a0683#0D
a0683#0D
a0683#0D
a0682#0D
a0682#0D
a0682#0D
a0682#0D
a0684#0D
a0684#0D
a0682#0D       only for test 20 "a" value's if all is working well this will be about 100+ value's
v0683#0D
i0910#0D
n0001#0D

this string is always the same.. only the value's are changing.
i set up the parser:
Sign of data packet's beginning: "[a-z]"    RE
Sign of data packet's ending:     "#0D".

the parser params:
item name: A
parsers type: fixed position
data type : integer
Fixed position: 0
Fixed length: 4
all the same for v, i and n.

if i now export this whit the direct excel connection he just fill in all the cells disregarding the letters.

what i want is all the "a" value's on a vertical row in colum A.. and the other's ( v, i, n) on a fixed position in other cells.
when a new string arrives all the previous t value's must be overwriten

i am trying it for days now but cant get it work

i hope some one can help me...

[Arthur Grasin]

Because all your data come to one serial port then you should define parser items like:

item name: ATYPE
parsers type: fixed position
data type : string
Fixed position: 1
Fixed length: 1

item name: AVALUE
parsers type: fixed position
data type : integer
Fixed position: 2
Fixed length: 5

You should activate the Script Execute plugin and write a small script that will place a value from the AVALUE item to different variables, depends on ATYPE value.

Also you may use Expressions data filter plugin and specify expressions like:

COL1 = IIF(ATYPE='a', AVALUE, '')
COL2 = IIF(ATYPE='n', AVALUE, '')
COL3 = IIF(ATYPE='v', AVALUE, '')

Please, note that the "Parse full data packet" option should be on.