Forum Discussion
Nick_M_UK
Mar 16, 2023Copper Contributor
Data Streamer Data Out
Possibly a stupid question but here goes: How does one configure data out to only send a single channel? Currently, the datastreamer is sending out the command text from CH0 followed by 9 commas which causes an error with the connected device as it only expects a single request.
Any ideas?
Thanks in advance
- NikolinoDEGold Contributor
Start streaming real-time data with the Data Streamer add-in
you can maybe use a formula like
=IF(LEN(CH0)>0,CH0&CHAR(10),"")
in cell A1 of your Data Out worksheet to send only CH0 data without commas.
- Nick_M_UKCopper Contributor
Many thanks for your reply. I'm unsure how that would help. The underlying code takes strings from cells A5 to J5 and concatenates then with a comma between each. If B5 to J5 are empty then you get a string transmitted as: GA00,,,,,,,,, where "GA00" is the contents of cell A5. What I actually need to send is the contents of cell A5
- NikolinoDEGold ContributorI'm not sure if I understood it correctly, but here's a quick solution proposal
=IF(LEN(CH0)>0,CH0&CHAR(10),IF(COUNTA(B5:J5)=0,A5,A5&","&B5&","&C5&","&D5&","&E5&","&F5&","&G5&","&H5&","&I5&","&J5))