[Koha] Sorting of accession numbers

[Jerwyn Fernandez]

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 <manojkumarmisra at gmail.com>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
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Jerwyn G. Fernadez
Basic Education Librarian
Southville International School and Colleges