How to update the subpart of the url (1000 Records)

Obito
Tera Expert

Hi All, 
On form we have one URL field and we do want to update some part and for some urls we want to update the starting part , there are more than 1000 records . what is the best approach to do this.

 

Thanks all.