Ask a Question related to FileMaker, Design and Development.
-
dan #1
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
-
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? ... -
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... -
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... -
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... -
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... -
dan #2
Re: Replace * with return characters?
LaRetta <member30258@dbforums.com> wrote in message news:<3093106.1057791188@dbforums.com>...
I tried converting all the ¶ to * to import them into the fields.> 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
Substitute only works for a single field.. I have to do 93 fields..
Dan
dan Guest
-
Howard Schlossberg #3
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



Reply With Quote

