Replace * with return characters?

Ask a Question related to FileMaker, Design and Development.

  1. #1

    Default Replace * with return characters?

    Is there a way to do this or not?

    I want to import a file with return characters but it seems
    impossible.
    even with the new find/replace function which doesn't replace
    invisibles worth a darn.

    And there are no escape characters???


    Help

    Dan
    dan Guest

  2. Similar Questions and Discussions

    1. Is there a way to replace characters in a string/array
      I am trying to find a function similar to php's str_replace is there something that will allow me to replace a certain character in a variable? ...
    2. replace carriage return with comma
      i am using <cftextarea> to input numbers on each line. when i submit the form it is outputting: 'number1 number2 number3'. well i am trying to...
    3. find replace a range of characters
      I need to find and replace a range of characters that are contained in brackets like below: It seems the brackets are throwing me off. I just...
    4. Replace characters in a Field when bindig data
      I have a drop down field on a form. When binding data to the DataValueField property of the drop down, I need to replace "&" with "%". In code...
    5. Using Replace function to remove two different characters
      I'm using replace function to strip 0s from a particular string: <%=replace(rs1("racelength"),"0","''"%> but I need to also strip empty spaces...
  3. #2

    Default Re: Replace * with return characters?

    LaRetta <member30258@dbforums.com> wrote in message news:<3093106.1057791188@dbforums.com>...
    > Hi Dan,
    >
    > Substitute (YourField, ""*"", "¶") or reverse it - I was unclear which
    > way you wanted to replace. Are you sure you want '*' in your db? I
    > assume you meant the other way around.
    >
    > Be sure you aren't using smart quotes - they are such a pest!
    >
    > LaRetta
    I tried converting all the ¶ to * to import them into the fields.
    Substitute only works for a single field.. I have to do 93 fields..

    Dan
    dan Guest

  4. #3

    Default Re: Replace * with return characters?

    Put all 93 fields on a layout and then take LaRetta's line and surround
    it in a script as follows:

    Goto Record [First]
    Goto Field [Next]
    Set Field [gFirstField, status(currentfieldname)]
    Loop
    Replace Contents ["Substitute (status(currentfieldname), ""*"", "¶")"]
    Goto Field[Next]
    Exit Loop If [status(currentfieldname) = gFirstField]
    End Loop


    dan wrote:
    > LaRetta <member30258@dbforums.com> wrote in message news:<3093106.1057791188@dbforums.com>...
    >
    >>Hi Dan,
    >>
    >>Substitute (YourField, ""*"", "¶") or reverse it - I was unclear which
    >>way you wanted to replace. Are you sure you want '*' in your db? I
    >>assume you meant the other way around.
    >>
    >>Be sure you aren't using smart quotes - they are such a pest!
    >>
    >>LaRetta
    >
    >
    > I tried converting all the ¶ to * to import them into the fields.
    > Substitute only works for a single field.. I have to do 93 fields..
    >
    > Dan
    --
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Howard Schlossberg (818) 883-2846
    FM Pro Solutions Los Angeles, California
    Associate Member, FileMaker Solutions Alliance

    Howard Schlossberg Guest

Posting Permissions

  • You may not post new threads
  • You may 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