samedi 18 avril 2015

How can I replace value at every 1000 line in Excel or Notepad++?

I have 1 lakh records and I want to do query for those records in production ..


so for every 1000 line I want to replace comma with a string value (or tablename.columnname in ())


example



1000) '12345',
---
---
---
2000)'123431',
---
---
---


to replace to



1000) '12345')or tablename.columnname in (
---
---
---
2000)'123431')or tablename.columnname in (
---
---
---

Aucun commentaire:

Enregistrer un commentaire