Sorting Data

[Mags1972]

Probably an easy one! but its got me stuck!!!

I have data coming in and would like to sort it, but only by using the FIRST 3 chars of the input.

i.e
Input
=====
D01:zzzzzzzz
D05:dddddddd
D02:eeeeeeee
D01:aaaaaaaa

I would like the output to read

D01:zzzzzzzz
D01:aaaaaaaa
D02:eeeeeeee
D05:dddddddd

But currently is is being sorted for ALL the data in the input.

Current output

D01:aaaaaaaa
D01:zzzzzzz
D02:eeeeeeee etc etc

Any ideas???

Thanks

 

[BocaBurger]

Break the data into two fields?
Use the LEFT function prior to the sort?



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[Mags1972]

I have tried both.

Using the LEFT function doesn't create any output! (although the map completes sucessfully)

By spltting the fields I have to then put these under a recurring group, which actually doesn't perform the SORT function, although once again the maps completes.

Any other ideas would be much appreciated.

Thanks in advance

 

[BocaBurger]

Send your LEFT function map to IBM Support so they can take a look at it. It should work if implemented properly.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!