Skip to main content
Nintex Community Menu Bar

Replacing A - E with 1 - 5

  • November 17, 2016
  • 2 replies
  • 13 views
Forum|alt.badge.img+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

    2 replies

    Forum|alt.badge.img+9
    • mlauer
    • November 17, 2016

    You can use nested replace fucntions:

    replace(replace(replace(replace(replace('ABCDE','A','1'),'B','2'),'C','3'),'D','4'),'E','5')

    Forum|alt.badge.img+2

    Thanks Manfred, that works well.

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement