Sort field names - Numeric prefix

Krish

I have field names like

01:Name ,04:Type ,10:Status,12:IsReady ,100:IsTested

When I use select tool - Sort option It sorts as follows

1:Name

4:Type

10:status

100:IsTested

12:IsReady

But I need to sort based on numeric value prefix

1,4,10,12,100

Thanks in advance.

Krish

Dynamic Processing

Preparation

Accepted answers

Krish

Attached sample flow .

somehow I could not pad 0s in string like 1:Key so I used string manipulation to solve this.

PadLeft( SubString([_CurrentField_],0,FindString([_CurrentField_],":")),3,"0")+SubString([_CurrentField_],FindString([_CurrentField_],":"),Length([_CurrentField_]))

Also used separate dynamic select for - ve values.

Thanks,

Krishna

Sample.yxmd

All comments

MarqueeCrew

You could text to columns with : as the delimiter and only output 1 field. Select the field and change the type to int16. Now you can sort on that field.

Cheers,
Mark

patrick_digan

@Krish You could also try a modified version of @AdamR_AYX's field sort macro from his Crew Macros. I've attached the macro. You would want to check the Use dictionary sort box (This was the feature that I added).

CReW_FieldSort.yxmc

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703