| Abe Jimenez 2006-07-31, 7:06 pm |
| I agree that changing the collating sequence is a better solution. But be
careful, this can have an effect on the rest of your program.
--
Regards,
Abe Jimenez
"Gerd" <schmittinger@unitech.co.za> wrote in message
news:1154088919.830659.8920@i3g2000cwc.googlegroups.com...
Thank you for your suggestion.
Found a better solution - see below.
Regards
Abe Jimenez wrote:[color=darkred]
> Actually you can make this work. What you need is to automate the
> process.
> I would add a BeforeAdd and a BeforeUpdate trigger to the file to
> automatically build the sorter field from the word field. All you need is
> a
> loop that will read each character in the word and replace it if necesary.
> For example:
>
> FIL:Sorter = ''
> Loop I# = 1 to Len(Clip(FIL:Word)) by 1
> Case FIL:Word[I#]
> Of ä
> Fil:Sorter = Clip(FIL:Sorter) & 'a'
> Of ..... !Create one of these for each letter you want to replace
> Else
> FIL:Sorter = Clip(FIL:Sorter) & FIL:Word[I#]
> End
> End
>
> --
>
> Regards,
> Abe Jimenez
>
>
> "Gerd" <schmittinger@unitech.co.za> wrote in message
> news:1153824881.767819.166910@h48g2000cwc.googlegroups.com...
> Thank you for the suggestion. Unfortunately it will not work since
> those Umlauts are all over (also inside the words) and to make these
> type of changes about 10,000 times, with new words being added
> continuously it will be an impossible task.
>
>
> Paul S. Person wrote:
|