Our Preferred 5 Star Hosting Provider - Award Wining FileMaker Pro Hosting
Results 1 to 4 of 4
  1. #1
    FREE Member
    Join Date
    Oct 2006
    Posts
    65
    Downloads
    0
    Uploads
    0

    Get First Letter of a Field Entry

    Is there any way to get the first letter of a field entry?

    I have a field ("Last Name") and I need a way to separate out the initial letter.

    Any suggestions?

    Thanks for the help.
    Warning: This is an Old Thread
    This discussion is older than 420 days. information contained in it may no longer be current

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - New York - Worldwide AHunter3's Avatar
    Join Date
    Aug 2006
    Posts
    11,514
    Location
    New York and Nassau County, NY, USA
    FileMaker Version
    FM 9, FM 9 Server, FM 10, FM 11, FM 11 Server, FM 12, FM 12 Developer
    OS
    Windows & Mac
    Skill Level
    Developer
    Downloads
    0
    Uploads
    0

    Re: Get First Letter of a Field Entry

    Left (Last Name, 1)

  3. #3
    Senior Moderator - FMT Preferred Developer Consultant - Netherlands, Europe, Asia, USA Maarten Witberg's Avatar
    Join Date
    Mar 2004
    Posts
    6,023
    Location
    netherlands
    FileMaker Version
    FM 10 Developer, FM 10 Server, FM 11, FM 11 Developer, FM 11 Server, FM 12, FM 12 Developer, FM 12 Server, Older Versions 2-8
    OS
    Windows & Mac
    Skill Level
    Developer
    Downloads
    0
    Uploads
    0

    Re: Get First Letter of a Field Entry

    left(trim(NameLast);1)
    should do the job

    maarten
    Stick to what you don't know.

    http://www.maartenwitberg.nl


    -------

  4. #4
    Senior Moderator - FMT Preferred Developer Consultant - Netherlands, Europe, Asia, USA Maarten Witberg's Avatar
    Join Date
    Mar 2004
    Posts
    6,023
    Location
    netherlands
    FileMaker Version
    FM 10 Developer, FM 10 Server, FM 11, FM 11 Developer, FM 11 Server, FM 12, FM 12 Developer, FM 12 Server, Older Versions 2-8
    OS
    Windows & Mac
    Skill Level
    Developer
    Downloads
    0
    Uploads
    0

    Re: Get First Letter of a Field Entry

    and to think madonna is singing "quicker than a ray of light" in my ear right now. well, not quick enough... smiley_cool
    Stick to what you don't know.

    http://www.maartenwitberg.nl


    -------

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Prevent Entry of Data in One Field if Another Field is Empty
    By mdo6 in forum FileMaker Pro 12 - All versions
    Replies: 2
    Last Post: 07-24-2012, 07:07 AM
  2. Creating a Modifiable Field t o Generate an Email/Letter
    By AHumphries in forum FileMaker Pro 12 - All versions
    Replies: 2
    Last Post: 05-10-2012, 12:58 PM
  3. Calculation for first letter or number each field
    By sst1000 in forum Calculations and Define Fields
    Replies: 4
    Last Post: 01-28-2009, 01:59 PM
  4. Stop entry to field based on previous field entry??
    By Stellardebris in forum ScriptMaker and Scripting
    Replies: 4
    Last Post: 01-21-2009, 06:10 PM
  5. Testing for only letter characters in a field
    By Jim McKee in forum Calculations and Define Fields
    Replies: 12
    Last Post: 08-07-2003, 02:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a free-to-join community where you can boost your FileMaker expertise, build better solutions and solve your technical challenges. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.