Hi Satish, maybe this piece of SQL code could help you... Please adjust the parameters @prefix and @offset. In the case you're satisfied with results, use the formulas in your UPDATE command. Regards, Radek select * FROM ( SELECT @prefix:="4GH" as cardnumber, @offset:=17 as university_id ) as vars where 0 = 1 union select cardnumber, CONCAT( @prefix, left(cardnumber, 2), MID(cardnumber, 3, 2), @offset + CAST(right(cardnumber, 2) as UNSIGNED INT) ) as university_id from borrowers Dne 19.01.18 v 7:21 SATISH napsal(a):
Dear Ramakant,
Yes, I did the same way for modification of a single cardnumber. but how to do it for bulk? and also data is in excel.
with thanks satish _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha