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 whic...
NikolinoDE
Mar 18, 2023Gold 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_UKMar 22, 2023Copper 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
- NikolinoDEMar 22, 2023Gold 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))- Nick_M_UKMar 22, 2023Copper ContributorNikolinoDE
Many thanks for your suggestions. The problem is in relation to the Data Streamer Add In and not any formula in any cell. There seems no way to access teh code.