[Koha] Sorting of accession numbers

[Doug Dearden]

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 at lists.katipo.co.nz [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of manoj382093
Sent: Sunday, March 30, 2014 9:54 PM
To: koha at 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 at gmail.com


On Sat, Mar 29, 2014 at 4:34 AM, Jerwyn Fernandez [via Koha] <
ml-node+s1045719n5792600h71 at 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.html
> > 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-tp5792591p5792600.html
>  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-tp5792591p5792647.html
Sent from the Koha-general mailing list archive at Nabble.com.
_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha