on 01-19-2007 10:15 AM
I want to be able to search a user database of Norwegian and Swedish users. Both languages have special characters, and the same name in Sweden and Norway could be written Björn in Swedish and Bjørn in Norwegian. I thus want the search field to send bj*rn to get both variants of the name.
This I can manage with REPLACE(@TEXT,'ø','*') in the Expression editor. BUT then I would have to check for both the Swedish and the Norwegian variants and in small and capital letters ie: ø,Ø,öÖ.
How do I do a multiple replace in a text string through the expression editor to get all variants:
REPLACE(@TEXT,'ø','*')
REPLACE(@TEXT,'ö,'*')
REPLACE(@TEXT,'Ø,'*')
REPLACE(@TEXT,'Ö,'*')
to be applied to the same text string?
Henning
I don't know how to do that in the VC, but I would try to have the database handle this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.