Re: Workaround with Substitute fucntion and diacritical marks

On Mar 27, 4:32 pm, stephen.wall...@xxxxxxxx wrote:
On Mar 27, 10:19 am, "Remi-Noel Menegaux" <rnmenegaux AT free.fr>
wrote:

I see how this would work. However, it would also render the actual
text that will be viewed later on without any of the diacritical
markings. It's weird, because when you do a normal search within
FileMaker it will overlook these markings and return both with and
without. I wish the substitute function had an option to modify how it
works.


I'm not sure what the issue really is. I could not get the
SingleHilite CF to highlight a word with an accented letter if only a
word with the unaccented letter was entered. Are you modifying the
SingleHilite or using it as is? What are the language settings for
the field? Are you using Substitute somewhere other than the
MultiHilite CF? Why do you suspect Substitute() is at fault?
.

Relevant Pages

  • Re: Copy exploded view from one assembly to another?
    ... might successfully re-attach the explode data (analagous to mates). ... exploded view and then modify or substitute some of the parts. ...
    (comp.cad.solidworks)
  • Re: Script to load security patches
    ... It used to refer to NT4.0 in it I believe. ... try to modify it and substitute NT4.0 configuration instead of W2003. ...
    (microsoft.public.win2000.security)
  • RE: Counting Texts
    ... since SUBSTITUTE is case sensitive you can modify this to read ... Shane Devenshire ... "Keith" wrote: ...
    (microsoft.public.excel)
  • Re: Text String Formula Q
    ... I modify that if Today-1 is anything other than a Sunday value, ... A general formula would be: ... So, in your string, substitute for A1, TODAY-1. ...
    (microsoft.public.excel.worksheet.functions)