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: [email protected] [mailto:[email protected]] On Behalf Of manoj382093 Sent: Sunday, March 30, 2014 9:54 PM To: [email protected] 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: [email protected] On Sat, Mar 29, 2014 at 4:34 AM, Jerwyn Fernandez [via Koha] < [email protected]> 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 [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
