String Input

[Olyn 0]

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

[Joe E. 259]

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.

[Olyn 0]

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!