hi Netta, How about splitting the values into two new string/pint fields and sorting on those in sequence? You can keep the original one for display purposes etc.
HTH, Andy On Thu, 10 Nov 2022, 10:07 Netta Steinberg, <nsteinb...@dalet.com> wrote: > Hi all, > > I want to sort value alphabetically, but also numerically. > Example: > I want that the following items > A1 > B4 > A2 > A19 > B10 > > Will be sorted in the following order > A1 > A2 > A19 > B2 > B19 > > So values that start with A will appear before values that start with B, > but also A2 will appear before A19, because the numerical value of 19 is > greater then the numerical value of 2. > I've seen similar questions in StackOverflow, but the suggestions were to > pad the values with zeros (so, e.g. A2 will become A02) but this is not an > option. > All > > Thanks, > Netta > >
