Hi guys! I know that it is an old topic , but I will try !
My DAQ board sends to PC data in the following format.
!voltage1[0],voltage2[0];voltage1[1],voltage2[1];voltage1[2],voltage2[2].....voltage1[n-1],voltage2[n-1]:TIMER4,TIMER5<CR>
! is the starting character
and we have "," , ":" and ";" as delimiters.
In the end of the packet (after ":") my board sends the values of two microcontroller timers (4 and 5).
The first data packet ends with a <CR> and my boards repeats that every 3 seconds.
I need to plot voltage1[n] and voltage2[n] in two separate graphs and my time base is the value of TIMER4 / n.
The real data is like showed below.
!0016442034,0000727890;0016499095,0000727024;0016543605,0000724990;0016568541,0000722157;0016578803,0000719243;0016587848,0000716010:0123456789,9876543210<CR>
I have used and modified altenbach's VI (https://forums.ni.com/t5/LabVIEW-Idea-Exchange/Contract-multiple-delimiters-for-quot-Spreadsheet-string-to/idc-p/1239830#M7564) but some delimiters are bothering me yet.
Modified Altenbach's VI
Case value 1 detail
The result is:
The VI was great to separate correctly the values of voltage1 and voltage 2 in two separate strings but I did not know how to avoid the last comma.
Also in Timer4 and Timer5 I could not avoid the characters ":" and "," right before the numeric values.
I would be grateful if anybody help to solve this issue or give me other tips to do what I need with that data.
Thank you everybody in advance !
DirtySpreadsheetStringToArrayVariable.vi