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
Solved! Go to Solution.
@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).
I will try both the options and update.
Thanks,
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