which operator/parameter should be used with V_String in IF Conditional formula

[nkapadia]

I have a check number field in Input data file which is V_String data type. I am trying to create additional column name in output as “Property Type” which is also V_String. I want to create a IF conditional formula if Check number starts with 007, then Property type value should be assigned as MS01 else CK13. I am not sure which operator/parameter should be used with V_String.

[binuacs · Accepted solution]

@nkapadia IF both field are string type you write the formula like below

IF StartsWith([number],'007') Then 'MS01'
Else 'CK13'
EndIf

[nkapadia]

Thank you!