Posted 27 Feb 2019 Hello everyone! I made an input on FactoryTalk View SE so the operator can encode the billet code. I am using 'STRING INPUT' because the Numeric Input don't accept alphabets/letters. I monitored the tags and it was actually a success, but when I'm trying to paste it on EXCEL (with RSLinx DDE/OPC) it shows only numeric value. Is there a way to decode it to make it an alphabet/letters? PS. check the photos. TIA Share this post Link to post Share on other sites
Posted 27 Feb 2019 I can't see in your screenshot, but it's probably importing the string value as the SINT[82] array, so each field contains the ASCII code for that character. In your example, "J" would be decimal 74, hex 0x4A. Do a Google search for ASCII tables to find a translation. Share this post Link to post Share on other sites
Posted 4 Mar 2019 On 2/27/2019 at 9:32 PM, Joe E. said: I can't see in your screenshot, but it's probably importing the string value as the SINT[82] array, so each field contains the ASCII code for that character. In your example, "J" would be decimal 74, hex 0x4A. Do a Google search for ASCII tables to find a translation. I managed to do it with a "CHAR" function in Excel. Thank you! Share this post Link to post Share on other sites