Does anyone know a way to sort a string column alphanumerically

(0) Share

Report

Posted on by EE-02081343-0

Hi,

I was wondering if there was a way to sort columns in an alphanumerical fashion. The column I am working on is a string type that contains both number and letter entries, but when I use the normal A-Z it will sort wrong due to the numbers actually being strings, so things will be sorted in this fashion:

110

dab

rather than:

110

dab.

I have been looking into it myself, but I have not found any way to do so and I am wondering if anyone here has a method to do so?

I have the same question (0)

All responses (5)

Answers (1)

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

What you see is the correct sorting of strings.

A possible solution may be, for example, using a computed column or an extra fields with values prefixed with space (e.g. ' 10' instead of '10'.

Which Dynamics product is your question about? (It would be better to ask in a specific forum instead of this general one.)

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

So how about using contains while doing the sorting instead of begins?

Was this reply helpful? Yes No
Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

Bhanari, can you explain that, please? Your suggestion doesn't make sense to me, but maybe I missed something.

"Contains" is useful when you want to know whether a string is contained in another string, but not for sorting. It also doesn't tell you at which position the string is and what characters are before it, which is crucial for sorting.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Hi Martin,

Sorry I understood the question in a different way like to check some small value in a larger value of type string. Yes, what exactly you said is right. Thank you for the correction.

Was this reply helpful? Yes No
Verified answer

Haig Liu Microsoft Employee on at

Like (0)

Report

Hi Partner,

Dynamic 365 views do not support multiple filter criteria on the same column, you can only create fields of the suitable data type to suit different filtering needs.

However, we can customize the sorting of the report after exporting the data:

https://support.microsoft.com/en-us/office/sort-records-on-numeric-values-stored-in-a-text-field-502a36c4-2b6e-4453-91b6-7e842d234157

Was this reply helpful? Yes No