[Koha] Koha Software- Data migration- To remove leading zero digit from Barcode/accession number

[Indranil Das Gupta]

Hi Manoj,

If you have already imported the data into Koha, then:

UPDATE items SET barcode = TRIM(LEADING '0' FROM barcode)

Followed by memcached restart and a Zebra reindex

hope this helps

Indranil Das Gupta
L2C2 Technologies


On Fri, 30 Sep, 2022, 12:14 pm Manoj Kumar, <manojkerl at gmail.com> wrote:

> Dear Team Koha,
>
> How can I remove a leading zero in the barcode entry in the case of a data
> migrated (from another software) environment?
> Can i do it in bulk of around 27000 biblio records
>
> Expert advice needed
>
>
> --
> manoj
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>