Nalisha, Resorting to SQL, this should do it:
update items set barcode=TRIM(LEADING '0' FROM barcode); Best, Ere Nalisha Tamang kirjoitti 25.2.2020 klo 11.52: > Dear all, > This time I need to change my barcode previously I had added 0 in front of > barcode number e.g if barcode is 2560 then I added 002560 to make it six > digit for 12 = 000012 but now I want only the numbers no leading zeros for > 4700 books is there a way to remove all leading zeros from the barcode?any > command???? > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > -- Ere Maijala Kansalliskirjasto / The National Library of Finland _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
