JMGA
-
Posts
2 -
Joined
-
Last visited
JMGA's Achievements
-
Replace, Substitute or Trim (Which One)
JMGA replied to JMGA's topic in Calculation Engine (Define Fields)
That's it! It works perfectly. Thank you so much. -
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.