Setting up ascii strings in lookout

[torr71]

Want to extract a number value from an ascii string and display this and update this value on a control panel ,also write in a value without having to enter the complete ascii string each time�.I think there is a way using excel to hold the sting and just fill in the correct cell �.. maybe�maybe not�Any Help here would be GREAT�.

[Khalid]

Hi,

To extract the numeric value from a string, you can use an expression similar to the following:

MID("test97string", 5, 2)

mid retrieves the substring from a given start position (5) and of a given length (2). Use Numeric as the Display Type when displaying on the panel.

For the second part of your question, you can insert a number into a string with something like this:

"Flow rate is " &TEXT(Pot1, "0.00")& "units."

Where Pot1 can be any numeric data source. And "0.00" is the format you wish the number to take in the string. If Pot1 is 3.14159, the resulting string will look like: "Flow rate is 3.14 units."

You can also use Symbolic links to combine text and numerics -- see Online Help on it for d
etails. Hope this gives you some ideas to explore.

Regards,

Khalid 🙂