27 Feb
2020
27 Feb
'20
2:56 p.m.
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 Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Ere Maijala Kansalliskirjasto / The National Library of Finland