Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    San Jose,Ca.
    Posts
    4

    Question Unanswered: can anyone help????Text Functions

    I have a field on which I need a calculated value output in the following formats:

    Imput Output
    Textfield 1 TextField1 Calc

    Laurel Crest LC
    Laurel Crest 1 LC1
    Laurel Crest 2 LC2
    Bella Vista BC
    Stonebrooke SB

    I need someone to teach me how to obtain an effective formula to grab the first letter of Textfield1 when textfield1 is equal to one word. I also need the formula to grab the first letter of the the first word and the first letter of the second word when textfield1 equals two words.
    last, I need the formula to grab the first letter of the first word, the first letter of the the second word, and the number of the thrid word..... Rudy,

  2. #2
    Join Date
    Sep 2003
    Posts
    26

    Calc

    If(WordCount(Field1)=1, Right(Field1,1), If(WordCount(Field1)=2, ....

    By using the word count and right commands you can develop this calculation.

    Hope that helps.

    www.fmdeveloper.com

Posting Permissions

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