Hi Manoj, You might be able to parse out the pieces by using MySQL string functions: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html For instance, you could use the Left function to get the two characters at the beginning of the string, and the Mid function to get the rest of the characters, then sort on the first two, then on the rest. Doug -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of manoj382093 Sent: Sunday, March 30, 2014 9:54 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Sorting of accession numbers Dear Friends, Is there no way we can do it by SQL Command in report writing. *Regards!* *Manoj Kumar Misra* M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.) Deputy Librarian SRMGPC Lucknow Mob. No.: 09415422579 Alternate E-mail: manojmisrasrmgpc@gmail.com On Sat, Mar 29, 2014 at 4:34 AM, Jerwyn Fernandez [via Koha] < ml-node+s1045719n5792600h71@n5.nabble.com> wrote:

Hi Manoj,

Maybe what you are try to say, you want to export your generated report arranged by barcode? Am I right?

In that case you may edit your data through excel.

*Steps*

Step 1

Highlight the whole column of the "barcode"

Step 2

click cnrt+H

Step 3

Find what = A Replace with = *note leave it blank

click Replace All

(so that you can remove the "A" symbol)

Step 4

Go to *Data* and sort your column to A - Z

Step 5

Make a new column beside the barcode column

then type ="A"&(the column with the number 1) then press enter

and then drag the formula to put A back

Regards,

- Jerwyn

On Sat, Mar 29, 2014 at 12:20 PM, manoj382093 <[hidden email]<http://user/SendEmail.jtp?type=node&node=5792600&i=0>>wrote:

...

Dear Friends, I have used alphabets in barcode numerbers for different item types, now when i have generated the accession register sorted by barcode it sort like A1, A11, A12, A21.. etc instead of A1,A2,A3,A4.....

Please help!

Manoj Kumar Misra

-- View this message in context:

http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.htm...

...

Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org [hidden email] <http://user/SendEmail.jtp?type=node&node=5792600&i=1> http://lists.katipo.co.nz/mailman/listinfo/koha

-- Jerwyn G. Fernadez Basic Education Librarian Southville International School and Colleges _______________________________________________ Koha mailing list http://koha-community.org [hidden email] <http://user/SendEmail.jtp?type=node&node=5792600&i=2> http://lists.katipo.co.nz/mailman/listinfo/koha

------------------------------ If you reply to this email, your message will be added to the discussion below:

http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p579... To unsubscribe from Sorting of accession numbers, click here<http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5792591&code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkyNTkxfC0xMDkzNzg1MDg0> . NAML<http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

-- View this message in context: http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p579... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha