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...
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.