Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006

    Unanswered: Remove character

    I'm importing data that is formatted with a (-) for example 1234-4567 and want to remove the (-) upon importing. I'm assuming this can be done with a calculation but not sure how - I've just begun using FM. Thanks, R

  2. #2
    Join Date
    Apr 2004

    On import?

    1 option, off the top of my head. If you have fm7 or 8

    Set one extra field as a calculation, evaluate and replace always, with Substitute importfield;"-";"" if you want the "-" to disappear.

    There are too many ways to do this with an existing field, so a calculation field seems the simplest for an import.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts