Forum Discussion

Nick_M_UK's avatar
Nick_M_UK
Copper Contributor
Mar 16, 2023

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

    • Nick_M_UK's avatar
      Nick_M_UK
      Copper Contributor

      NikolinoDE 

       

      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

       

       

      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor
        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))

Resources