Re: Workaround with Substitute fucntion and diacritical marks
- From: Grip <grip@xxxxxxxxxxxxx>
- Date: Thu, 27 Mar 2008 06:36:31 -0700 (PDT)
On Mar 27, 7:19 am, "Remi-Noel Menegaux" <rnmenegaux AT free.fr>
wrote:
My way to solve this is to first create a global in which the user puts its
criteria.
Then I create a script in which one step is to Replace into a global (or
variable) the 'TTBS' = 'Text To Be searched' any 'wrong' character by a good
one. Ie it could look like this (pseudo code) :
Set Field (
Substitute ( Substitute ( Substitute ( Substitute ( Substitute ( Substitute
( Substitute ( Substitute ( Substitute ( Substitute (
Working_Text; " "; ""); "CR"; ""); "é"; "e")etc..
))))))))))
(where 'CR' stands for 'Carriage Return')
Then you apply the same formula to the search criteria and you make a 'Find'
of the modified criteria into the Working Text.
There are maybe more elegant ways to do that.
HTH.
One neat feature of the Substitute function eliminates the need for
nested Substitutes, using one sub and optional square brackets. So,
instead you can say Substitute(Working_Text; [" " ; ""]; ["CR"; ""];
[etc;etc]).
.
- References:
- Workaround with Substitute fucntion and diacritical marks
- From: stephen . wallace
- Re: Workaround with Substitute fucntion and diacritical marks
- From: Remi-Noel Menegaux
- Workaround with Substitute fucntion and diacritical marks
- Prev by Date: Re: Workaround with Substitute fucntion and diacritical marks
- Next by Date: Re: Bento
- Previous by thread: Re: Workaround with Substitute fucntion and diacritical marks
- Next by thread: Re: Workaround with Substitute fucntion and diacritical marks
- Index(es):
Relevant Pages
|
