- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2024 08:51 AM
Hi. I have a very basic password system that uses letters to denote numbers. The numbers come from a client's DOB.
I have a date (DOB) field and another field using DATETIME_FORMAT to only show the numbers (DDMMYY). That's all fine.
I would like to have a new field that displays a particular letter for each number - to create a very simple password. Lets say: 1=a, 2=b, 3=c, 4=d, 5=e, 6=f, 7=g, 8=h, 9=i, 0=j
Is there a formula that would do this please?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2024 10:23 AM
Hi, this is the only way that I could think about, Let me know if you have any question 🙂
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Number},"0","A"),"1","B"),"2","C"),"3","D"),"4","E"),"5","F"),"6","G"), "7","H"),"8","I"),"9","J")
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2024 10:23 AM
Hi, this is the only way that I could think about, Let me know if you have any question 🙂
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Number},"0","A"),"1","B"),"2","C"),"3","D"),"4","E"),"5","F"),"6","G"), "7","H"),"8","I"),"9","J")
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2024 10:43 AM
Thanks so much. I know it's not pretty - but it works perfectly! 😄
