Re: BUG in FileMakerPro
- From: Howard Schlossberg <howard@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 30 Dec 2005 08:45:17 -0800
Boubahha wrote:
v7 dev and v8 Pro
2 fields :
DATA_1 : Text DATA_2 : Substitute ( " " & DATA_1 & " "; " la "; " ")
BUG :
"la lampe la la" > DATA_1 " lampe la " > DATA_2 ???!! Why isn't it " lampe " ??!
Is it a bug?
FileMaker is substituting all unique patterns of " la " from the original value. The space between the last two la's is unique to only one of those la's and is therefore ignored for the other la.
If you are sure there will never be more than two la's in a row, then you can use something that performs up to two substitutions:
Substitute ( " " & DATA_1 & " "; [" la "; " "]; [" la "; " "])
Or if you can't predict how many consecutive la's there might be, and since you have FM Developer 7, you can define a custom function that uses recursion to do what you want, a sample of which is at http://www.briandunning.com/cf/40
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Schlossberg (818) 883-2846 FM Pro Solutions Los Angeles, California
FileMaker 7 Certified Developer Associate Member, FileMaker Solutions Alliance .
- Follow-Ups:
- Re: BUG in FileMakerPro
- From: FP
- Re: BUG in FileMakerPro
- References:
- BUG in FileMakerPro
- From: Boubahha
- BUG in FileMakerPro
- Prev by Date: Re: Populating a field from account login...
- Next by Date: Re: new calendar
- Previous by thread: BUG in FileMakerPro
- Next by thread: Re: BUG in FileMakerPro
- Index(es):
Relevant Pages
|
