The middle part

[mcstafford]

Hello,

I would like to transform this:
/*!40101 SET character_set_client = utf8 */;

into this:
SET character_set_client = utf8;

I can highlight the parts I want to remove using grep, e.g.

grep --extended-regexp '^\/\*![0-9]{5}' file.txt
# or
grep --extended-regexp '\*\/$' file.txt

How do you recommend I clear out the bits I don't want?

Thanks,

Mark

 

[p5wizard]

This? (I just typed this, it is untested)

awk '/*\/;$/{
 for (i=2;i<NF;i++){
  printf "%s ",$i
 }
 printf "\n"
}' /path/to/inputfile

HTH,

p5wizard

 

[mcstafford]

Thanks, p5wizard.