john777

Newbies
  • Content count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About john777

  • Rank
    newbie
  • Birthday

FIleMaker Profile

  • FM Application
    15 Client
  • Platform
    Mac OS X El Capitan
  • Skill Level
    Novice
  • Title
    consultant
  • Industry
    print
  1. Hello Am trying to clean up the email field on a filemaker database. At the moment there are many records that contain more than one email address or an email address and text. what I want to do is delete everything in the field apart from the first email address In the vast majority of cases the required email address is the first thing in the field. So my thinking is that the script would have to read along until it found an "@" symbol and then truncate the text at the next space comma or backward or forward slash as they are generally the methods people have used to separate the email addresses. Apart from that am struggling - I would be delighted if someone could give me some pointers on this