4 Replies Latest reply on Oct 31, 2018 6:35 AM by Jim Dehner

    calculated field that groups on first character (number or letter)

    sander van der Velden

      Hi guys,

       

      at my company we use certain codes, most codes contain only 5 numbers (12345), but there are some cases where the code starts with a letter, with 4 numbers (H1234).

      I would like to group these 2 options, so if it starts with a letter, then group as 'code with a letter' (or something like that).

       

      I do need seem to get the solution to do this...

       

      I do not want to say in my formula that if it starts with a A or a B or a C, then it will be grouped, but I want to identify it as a letter.

       

      Can you please help me out on this?

       

      Sander