Forum Discussion
Data Streamer Data Out
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.
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
- I'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))- NikolinoDE
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.I'm at the end of my wisdom (even if that sometimes doesn't mean much :)).
My final thought on this...
To configure data out to only send a single channel in Data Streamer, you can adjust the parameters for the Data Out function in the Workbook Settings tab when the Data Streamer add-in is enabled.
Adjusting these variables will change the amount of data displayed, the rate data is displayed, and the direction the data flows through the data tables on the Data In and Data Out tabs.