Find and Replace script

[Trond Hoyem]

You can fix encoding of your ESF here: https://openrb.com/convert/

Yea, but as I recall, that one does not work with large files. 
It is not a big thing, we are normally not using the special characters, but sometimes they are there.. :-)

For anyone that might need the same function, Here is the working code, a little cleaned up:

Code:

finn = 'Text to find'
replace = 'Text to add'
kriterie = 'Filter criteria'

liste = db:getall('SELECT name, id FROM objects WHERE name LIKE "%'.. kriterie .. '%"')

for _, name in ipairs(liste) do
  navn = name.name
  newName = string.gsub(navn, finn, replace)
  log(navn, newName)
  db:update('objects', { name = newName }, { id = name.id })
end
log('FINISHED')

script.disable(_SCRIPTNAME)