+2
Hi
I have been trying to figure out if I can use forms inline function replace() for replacing the letters A to E with the numbers 1 to 5, ie. A becomes 1, B becomes 2, etc. I have not been able to figure this out so was wondering if anyone could help?
Thanks
+9
You can use nested replace fucntions:
replace(replace(replace(replace(replace('ABCDE','A','1'),'B','2'),'C','3'),'D','4'),'E','5')
+2
Thanks Manfred, that works well.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.