i have a string of which looks like below and looking for xquery help. Some of the blocks have Status=Complete and some have Status=InProgress
Hello Action=C,Status=InProgress Action=I,Status=Complete Action=J,Status=Complete Action=H,Status=*InProgress* Action=M,Status=Complete ;
the out put i'm looking for is all the Status=InProgress blocks should come first and the Status=Complete later like the below .
Hello STBAction=C,Status=InProgress Action=H,Status=*InProgress* Action=I,Status=Complete Action=J,Status=Complete Action=M,Status=Complete ;
can some body help with the xquery for the above .. or is there any function which does that ?