sorting a text field containing text and numbers ???

(0) Share

Report

Posted on by jaybeegee

193

Hello! appreciate that this is a rather strange request as the A-Z sort by Quote Name is working as it should however we have a specific request to have the sorting on the number suffix (!) So in the example below we would have the 10 then 20 then 30 etc...then eventually 100 and so on. Is this anyway possible wiithout any progrgamming maybe using some naming conventions?

Quote Name

Test Quote No. 10

Test Quote No. 100

Test Quote No. 110

Test Quote No. 120

Test Quote No. 130

Test Quote No. 140

Test Quote No. 150

Test Quote No. 160

Test Quote No. 170

Test Quote No. 180

Test Quote No. 190

Test Quote No. 20

Test Quote No. 200

Test Quote No. 210

Test Quote No. 220

Test Quote No. 230

Test Quote No. 240

Test Quote No. 250

Test Quote No. 260

Test Quote No. 270

Test Quote No. 280

Test Quote No. 290

Test Quote No. 30

Test Quote No. 300

Test Quote No. 310

Test Quote No. 320

Test Quote No. 330

Test Quote No. 340

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member on at

Like (2)

Report

Hi jay ? bee ? gee ?,

There is no way to directly achieve this by sorting name because it's type is string which is sort by each char in ASCII.

As a workaround, you could create a Calculated field which get the number in your name:

Then convert this field from Text to Whole Number by Attribute Manager in the XRM ToolBox:

After this succeed, add the field to your view and sort by it.

Result:

Was this reply helpful? Yes No
jaybeegee 193 on at

Like (0)

Report

omg that is incredibly smart!

Was this reply helpful? Yes No