Calculate string expression

[rikard.nilsson4SLAL]

Hi,

I'm trying to calculate an expression in a string to create a double in iLogic.

I've done som e searching and I think is DataTable is the best way of solving that. I try with the the row below.

result = New DataTable().Compute("1 + 2 * 7", Nothing))

 But I get that DataTable is not defined.. 

I tried with different imports like..

Imports System.Data

But nothing works.

Does anybody know what I should import to get this working in iLogic or do anybody have another solution how to calculate string expressions?

Regards

Rikard

[FINET_Laurent · Accepted solution]

Hello @rikard.nilsson4SLAL,

You need to add the references first before importing the class :

AddReference "System.Data.dll"
AddReference "System.Xml.dll"

Imports System.Data
Imports System.Xml

Sub Main()
    Dim expression As String = "1 + 2 * 7"
    Dim result As Object = New DataTable().Compute(expression, Nothing)
	
	MsgBox(result)
End Sub

Kind regards,

FINET L. 

[rikard.nilsson4SLAL]

Yes of course!!
Thank you so much!

/Rikard