Lalla Belle
asked on
Substring & replace function in case statement
Hi,
I need to write a formula, that will replace certain characters with other characters if it encounters them in a string.
What I want is something like this:
Select Case {mydb_txt.Field1}
Case ("+®")
formula=UCASE(Replace ({mydb_txt.Field1},"+®","é "))
Case ("+Ë")
formula=UCASE(Replace ({mydb_txt.Field1},"+Ë","ç "))
End Select
It doesn't work however.
Please help
I need to write a formula, that will replace certain characters with other characters if it encounters them in a string.
What I want is something like this:
Select Case {mydb_txt.Field1}
Case ("+®")
formula=UCASE(Replace ({mydb_txt.Field1},"+®","é
Case ("+Ë")
formula=UCASE(Replace ({mydb_txt.Field1},"+Ë","ç
End Select
It doesn't work however.
Please help
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.