Professional Web Applications Themes

Remove character at end of text string - FileMaker

Removed by Administrator...

  1. Moderated Post

    Default Remove character at end of text string

    Removed by Administrator
    Guest
    Moderated Post

  2. #2

    Default Re: Remove character at end of text string

    <com> wrote:
     

    Leftwords(phone number, 4) will do this trick.

    --
    Hans Rijnbout
    Utrecht, Netherlands
    Hans Guest

  3. #3

    Default Re: Remove character at end of text string

    nl (Hans Rijnbout) wrote in message news:<1g7zh6o.69npx21vlvuh4N%nl>... 
    >
    > Leftwords(phone number, 4) will do this trick.[/ref]

    That may work for this data, but I don't like relying on the "word"
    functions. Who knows what data will be in there and mess it up?
    Consider the following:

    case(
    right(phone number,1) = "-", 'is the rightmost
    character a "-" ?
    left(phone number, length(phone number) - 1), 'if it is, remove the
    rightmost char
    phone number
    'otherwise, leave it alone
    )

    Use the replace menu command, but do yourself and me a favor and do it
    on a backup file in case I wrote it wrong.
    Paul Guest

Similar Threads

  1. Question Remove character from xml while importing
    By Unregistered in forum Brainstorming Area
    Replies: 0
    Last Post: November 18th, 03:16 PM
  2. Remove all paragraph and character style overrides
    By jaime_ash@adobeforums.com in forum Adobe Indesign Windows
    Replies: 5
    Last Post: October 11th, 01:35 AM
  3. Remove HTML in a string and Leave text
    By mjmibill in forum Coldfusion Database Access
    Replies: 3
    Last Post: December 9th, 03:18 AM
  4. First Character in a string
    By brutas in forum Macromedia ColdFusion
    Replies: 1
    Last Post: March 2nd, 07:11 PM
  5. Replies: 4
    Last Post: September 12th, 04:19 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139