This may seem like a ridiculous question, but I can't figure it out to save my bacon.
I have a SQL file that is missing a single quote around a text field.
I am attempt to do a global search-and-replace from the command line as this is a one time deal. Unfortunately, it isn't working like I think it should.
When I attempt the following from the unix prompt I get a prompt for more input as follows:
thug:/tmp> perl -p -i -e 's/ where/' where/g' *.sql
I even attempt to escape the single-quote, to no avail:
thug:/tmp> perl -p -i -e 's/ where/\' where/g' *.sql
I know it must be something small I am overlooking.