Calculation search for values starting with...

[McScripta]

I'm trying to implement an If statement in my calculation. It works fine as below but that limits found field values only to the specific string - "Part A". I need to be able to also catch values that may have text following the string I have specified, i.e. "Part A and something else". Any suggestions appreciated.

If ( tableName::fieldName = "Part A" ; resultOne ; resultTwo )

[comment]

If I understand correctly, you want the calculation to check if the text in a field starts with a given string. This can be done as follows =

If ( Left ( tableName::fieldName ;  6 ) = "Part A" ; resultOne ; resultTwo ) 

 

 

Edited November 20, 2015 by comment

[McScripta]

Yes, thank you. This works.