0

Sorting by "truncated" value

I have the following codes as Item Variant codes:

Code

ZMF21, ZMH20, ZMH21, ZMK20, ZMK21, ZMN20, ZMQ20, ZMV20, ZMZ20.    

I'd like my JetReport to sort first by right (2), then by code.  (i.e. the right (2) designate the fiscal year.).   These variant codes are "externally determined", so I can't "rename" the variant codes.   

How do you create a sort by specific characters within a string is the more universal question?    

 

 

 
 
 
 
ZMH20
 
 
 
 
ZMH21
 
 
 
ZMK20
 
 
 
ZMK21
 
 
ZMN20
 
 
 
 
 
ZMQ20
 
 
ZMV20
 
 
 
ZMZ20

 

2 comments

Please sign in to leave a comment.