Replace, Substitute or Trim (Which One)

[JMGA]

Hello,

I have been trying (unsuccessfully) to calculate a portion of an existing field into a new field in FM9 PRO. I have tried Replace, Substitute and even Trim to complete it, but since I am new to scripting I have not been able to get the desired result.

I have a field that contains a part number (3M-1234; DWT-CP-3429; ACM-00-98-A) and I want the calculated result of the new field to just be the characters before the first "-" (3M; DWT; ACM). Is it possible to extract that? If so, how? Any help would be appreciated. Thanks.

[comment]

Try =

GetValue ( Substitute ( PartNumber ; "-" ; ¶ ) ; 1 )

[JMGA]

That's it! It works perfectly. Thank you so much.