i have this junk code injected into a mysql database for a word press site.

what is the best way to strip that out?

what do you want to strip out?

You want to extract that from something or you wish to extract something from that?

You will need to be a lot clearer if you want help.

sorry i should have been more clearer.

here is what i have:

here is what i want:

i just need to strip that junk code out.

Sounds fair enough ... what have you done and where are you stuck?

If not sure of a tool, then sed could easily remove what is shown.

1 members found this post helpful.

With this InFile ...
... this awk ...
... produced this OutFile ...
Daniel B. Martin

2 members found this post helpful.

i was able to accomplish what i needed ... since it was a sql database dump, i was able to open it up in sql management studio and the find/replace tool in sql management studio actually did the job.

i do not really like that i used a microsoft tool to do a job linux could handle ... i just am not that powerful with advanced text manipulation.

what really stumped me was all the special characters in that junk code (i.e. <> % @ " \), i don't know how to escape those out.

given this example, can sed or awk strip out text that is between a string?

for example, can i tell sed/awk to strip out anything between "I WANT THIS" and "I WANT THIS"?


edit:
i asked my question after danielbmartin posted his.

from what you posted daniel, that looks a lot like what you told me how to efficiently text manipulate a few months back. i guess as soon as i saw all those special characters in my code, i got intimidated and immediately thought i didn't know how to do that.

thanks for being patient and informative.

2 members found this post helpful.

Extra points for being so concise. Love it!

Daniel B. Martin

1 members found this post helpful.

Pleased to be of service!

This is a variation on my awk solution posted earlier today. The method is the same but this solution uses fewer keystrokes.
Daniel B. Martin

1 members found this post helpful.

Here is a slightly more confusing awk

1 members found this post helpful.

If you want to stop users inserting html or javascript tags in your wordpress you can wrap a

strip_tags($insertText)

around the value to be inserted in the mysql but probably wordpress has a config param for that.

1 members found this post helpful.

It works but I don't understand it. Please explain.

Daniel B. Martin

-F" <.*> " - - Set field separator (FS) to regex value

'$1=$1' - - recalculate the line replacing FS with OFS. Also, it equates to true, hence print the line

2 members found this post helpful.

Clever!

Daniel B. Martin

1 members found this post helpful.