Hey Guys,

Im inheriting a project that uses piklist and I could use some help. Im not super familiar with piklist but I do have an odd problem. In this existing site the developers createda field, lets say “file_location”. In this field they put the value to “http://domain.com/path/to/file”. The goal is to make domain.com a variable within the code. This means that I need to strip “http://domain.com/” from the several hundred objects. In most plugins I would dump the database and use sed

`sed -i ‘[email protected]://domain.com/@@g’ dump.sql

However, when I do this, all of the entries just dissapear as if they were never there in the first place. What is the best way to accomplish this? I guess I could write in the php code to rewrite that variable and do a replace but thats ugly and kind of dumb. Thanks for your help!