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, <[email protected]> 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 > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
