Hi All,

There are book titles like the following when sorting by ascending, they become:
xxxx Book Five
xxxx Book Four
xxxx Book One
xxxx Book Three
xxxx Book Two

xxxx Volume 1
xxxx Volume 10
xxxx Volume 2
xxxx Volume 3 etc

'xxxx' are same titles, but with different volume etc.
Obviously, this is not the customer want. Could somebody advise if CR XI can sort the above in a correct order by converting Five to 5 etc.
By the way these books are displayed in the detail secion.

Hi Lockwelle,

Thansk for your suggestion. I'm afraid the customer may not like Book 1 instead of Book one which is the 'real' title.

I was using the following coversion routine obtained from SAP CR forum, the result of displaying is just as what you have said.

The codes:

local stringvar array toclean ;// text to delete into title
local stringvar array numberlist ;// list number in text in
local stringvar sortvolume;
local numbervar sortnum;
local numberVar counter;
local stringVar booktitle;
local stringVar booktitleb;
 
 
numberlist:=["zero","one","two","three","four","five","six"];
toclean:=["Book","volume","episode"];
sortvolume:={HEADING.HEAD};//book title
 
// find book title and order infos
for counter:=1 to UBound(toclean) step 1 do
(
    if lowercase(toclean[counter]) in lowercase(sortvolume) then
    (
    booktitle:= left(sortvolume,(InStr(lowercase(sortvolume),
lowercase(toclean[counter])))-2);
    booktitleb:=mid(sortvolume,InStr(lowercase(sortvolume),
lowercase(toclean[counter])));
 
    exit for
    )
);
 
 
// delete words from toclean into sortvolume
for  counter:=1 to UBound(toclean) step 1 do
booktitleb:= trim(replace(booktitleb,toclean[counter],"",1,-1,1));
if isnumeric(booktitleb)=true then sortnum:=ToNumber (booktitleb);
 
 
//look up if words from numberlist is equal to sortvolume if yes allocate number at place
for counter:=1 to UBound(numberlist) step 1 do
(
    if numberlist[counter]=booktitleb then
    (
    sortnum:=counter-1;
    exit for
    )
);
 
 
//create sort field with book title and sortnum
if sortnum<10
then  booktitle+" 0"+totext(sortnum)
else
booktitle+" "+totext(sortnum)

 

 

Great stories for kids. 01.00

Edited by johnwsun - 13 May 2009 at 3:18am

Hi Lockwelle,

I think I should give it up. thanks for the help anyway.

John