EditPlus replacing a wrapped Excel table with SQL statement techniques

When such data is placed in the in statement in SQL, the format needs to be wrapped and ', ' such content.

What to do:

Operate with the EditPlus. Ctrl+h find the place to enter \ n, replace the place to fill ', ' meaning that whenever there is a line break with ', ' to replace the note is the need to tick the final result of the regular expression is as follows:

Integrated Voice ',' access business ',' Integrated Voice Services ',' Integrated Voice Access ' ' , ' terminal marketing

Final sql:

SELECT * from Course_maininfo where  course_name like '% ' haulage ' network--branch network regional manager training% ' and Del_time is nullselect * from Cou Rse_mark   where   seqcode=12732 and mark_name not in     (' Training ', ' haulage ', ' mobile network overview ', ' Network Chapter ') and   deleteorno= ' 0 '                     ----0  show 1 not shown

Complete the task. Some Excel tips and Word skills need to be learned, which are sometimes more important.

EditPlus replacing a wrapped Excel table with SQL statement techniques