[Koha] Remove leading zeros from barcode

[Ere Maijala]

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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> 

-- 
Ere Maijala
Kansalliskirjasto / The National Library of Finland