Sorting the string with comma separated numbers and assign sequence

Question

I have a string value coming as "AH-0000006620, AH-0000006619, AH-0000006621", where I need to Remove the Prefix and the remaining numbers "0000006620, 0000006619, 0000006621" to be sorted in Ascending order and I want to store the sequence number for each of them like for 0000006619 value to be 1 for 0000006620 value to be 2 for 0000006621 value to be 3

So that when I send the info to target system, while iterating the array, for the first element if it is 0000006620 then I will pass the value as 2 for the other sequence tag. Please let me know how I can achieve this.

Answer 1

You can tweak this though this should serve as a good starting point to what you are looking for:

Script

%dw 2.0
import * from dw::core::Strings
output application/json
var inp = "AH-0000006620,AH-0000006619,AH-0000006621"
---
{((inp replace"AH-" with "") splitBy "," map ($ replace /^0+/ with "") orderBy $ map {
     (leftPad($ as String,10,0)) : ($$)
})}

You can do it this way as well.

{((inp replace"AH-" with "") splitBy ","  orderBy $ as Number map {
     ($) : ($$)
})}

**Output**

[ { "0000006619": 0 }, { "0000006620": 1 }, { "0000006621": 2 } ]