Hello,
I am trying to import machine data from a Controllogix PLC (L71) into an excel spreadsheet for my operations people to view from their cozy desk. I am using the Copy DDE/OPC Link method in RSLinx from my online processor topic. I can import most of the data easy-peasy as they are just decimal imports, but I am struggling with importing strings.
I have found previous threads that describe how to import strings and convert the data from decimal to ascii, which was very helpful. But the string I am trying to import has data of varying length. So the first import it may be 9 characters long and the next may be 5. How can I control the length of the string to import in Excel? I know there's a block size option in the RSLinx copy part, but is there a way to have that read the length of the string and adjust accordingly? I guess what I'm asking is there a way to cut off the imported string data based on it's length? Thank you in advance!!
I am trying to import machine data from a Controllogix PLC (L71) into an excel spreadsheet for my operations people to view from their cozy desk. I am using the Copy DDE/OPC Link method in RSLinx from my online processor topic. I can import most of the data easy-peasy as they are just decimal imports, but I am struggling with importing strings.
I have found previous threads that describe how to import strings and convert the data from decimal to ascii, which was very helpful. But the string I am trying to import has data of varying length. So the first import it may be 9 characters long and the next may be 5. How can I control the length of the string to import in Excel? I know there's a block size option in the RSLinx copy part, but is there a way to have that read the length of the string and adjust accordingly? I guess what I'm asking is there a way to cut off the imported string data based on it's length? Thank you in advance!!