• Replies 8 replies
  • Subscribers 22 subscribers
  • Views 54 views
  • Users 0 members are here
Options
Related

To read value type in UFL Interface

PrasadChaudhari01

Hi All,

 

I am trying to set up the UFL interface where it will read the data from CSV file which contain 'tagname', 'timestamp', 'value'. There will 42 different tag in that CSV. all tag value are float excel last one which have string value.

I am trying to write the IF else loop in INI file but it is not accepting the syntax. could you please help me to understand how can I ready value type in INI file.

 

FIELD(1).NAME="Tag"

 

FIELD(1).TYPE="String"

 

FIELD(2).NAME="TimeStamp"

 

FIELD(2).TYPE="DateTime"

 

FIELD(2).FORMAT="yyyy-MM-dd hh:mm:ss"

 

FIELD(3).NAME="Value_Number"

 

FIELD(3).TYPE="Number"

 

FIELD(4).NAME="Value_String"

 

FIELD(4).TYPE="String"

 

 

[MSG]

 

MSG(1).NAME="Data"

 

 

[Data]

 

Data.FILTER=C1=="*"

 

Tag=["(*),*,*"]

 

TimeStamp=["*,(*),*"]

 

Value_Number=["*,*,(*)"]

 

Value_String=["*,*,(*)"]

IF (Value_Number is Number) THEN

 

StoreInPI(Tag, ,TimeStamp,Value_Number, , )

 

ELSE StoreInPI(Tag, ,TimeStamp,Value_String, , )

 

ENDIF

 

in IF loop at Number position I am getting syntax error. 

 

Kind Regards,

Prasad

Parents
No Data
Reply
  • in reply to PrasadChaudhari01

    I really should have tested my solution before suggesting it. It looks like I am mistaken.

     

    We both should have checked the user guide. There is a function called IsNumber that checks if a string variable is a number. So you would extract your value only into Value_String. If IsNumber(Value_String), then set Value_Number = Value_String and store Value_Number in PI, else just store Value_String in PI.

Children