I am wanting to perform a sort on a field named ‘FormNumber’, but only on the prefix (the prefix can be 2-4 characters). A ‘FormNumber’ could be “FORM-123”, “FORM-456”, or “FM-123”.
Using those form names, I want to sort and categorize by whatever form prefix is before the dash. (e.g. “FORM-123” and “FORM-456” would be sorted and categorized under “FORM”. The “FM-123” would be categorized under “FM”.
You say you want to sort by the prefix, but a standard sort would do this surely?
If you’re wanting to categorise then you need a categorised view column with @Left(FormNumber;“-”), that is assuming that the delimiter is always a hyphen