combining text and parameter in ilogic

[Geertvdheide92]

Hello, 

I am trying to combine a parameter and text in ilogic if then statement.

the code is saying ')'excpected.

the code i'm using is this: 

SyntaxEditor Code Snippet

If Standard=1 Then
Size= (Size_2, "In")
ElseIf Standard=2 Then
Size=(Size_2,"mm")
End If

 Size_2 is defined using a excel sheet. 

I set the parameter property format to 0 decimals and no units showing. 

So if standard 1 and size_2 is 6mm 

In NXTdim the property Size should show 6 in

Or can i edit the formula of "Size" using a formula in custom properties

for example Size= <Size_2> <unit> 

but i cant export a text format to custom properties, so not sure if this is possible. 

is there a simple option for this issue?

kind regards

[bradeneuropeArthur]

I assume you are Dutch Op based Van NXTDIM?

Could you please explain:

Standard:  is a parameter or a property and comes from excel

Size: is a parameter or a property and comes from excel

Size_2: is a parameter or a property and comes from excel

Standard :is a parameter or a property and comes from excel.

kun je wat meer details geven mbt je wil doen.

Ik begrijp niet helemaal wat je wil doen.

Misschien dat nederlands helpt!!

[Geertvdheide92]

yes im dutch, 

i continue in english so it may help other people

I want to describe the size of a part. 

Depending on the values i get from my excel the units should say "in" or "mm"

in my  case the standard and size are values i put in inventor, so i get multiple values from excel.

depending on only the standard value i want to change the units described in the Size.

currently i found a workaround that works fine. 

the code is: 

SyntaxEditor Code Snippet

If Standard=1 Then
iProperties.Value("Custom","A")=GoExcel.CurrentRowValue("A_1")
iProperties.Value("Custom","B")=""
ElseIf Standard=2 Then
iProperties.Value("Custom","A")=""
iProperties.Value("Custom","B")=GoExcel.CurrentRowValue("B_1")
End If

in Excel column A has the value "in" and Column B has the value"mm"

next in custom properties for Size i have the formula

Size= <Size_2><A><B>

so if standard=1 then A= in and B is empty

this way i can combine numbers and text in the custom properties. 

[bradeneuropeArthur]

So may I understand you solved it yourselves?

[bradeneuropeArthur · Accepted solution]

Could be a little bit shorter and less code:

If Standard=1 Then
iProperties.Value("Custom","Size")=Size_2.Value  & GoExcel.CurrentRowValue("A_1")
ElseIf Standard=2 Then
iProperties.Value("Custom","Size")=Size_2.Value  & GoExcel.CurrentRowValue("B_1")
End If

If Standard=1 Then
iProperties.Value("Custom","Size")= Parameter.Param("Size_2").Value & GoExcel.CurrentRowValue("A_1")
ElseIf Standard=2 Then
iProperties.Value("Custom","Size")= Parameter.Param("Size_2").Value & GoExcel.CurrentRowValue("B_1")
End If

[Geertvdheide92]

Ah thank you, 

this is indeed the way i was trying to find to combine 2 different types of parameters.

[bradeneuropeArthur]

Maybe it could be easier without Excel if you want too!