regex - replace characters in notepad++ BUT exclude characters inside single quotation marks(3rd) -

this question has answer here:

• replace characters in notepad++ exclude characters inside single quotation marks(2nd) 1 answer

replace characters in notepad++ exclude characters inside single quotation marks replace characters in notepad++ exclude characters inside single quotation marks(2nd)

sorry, sorry users (especially avinash raj + jonny 5) answered successfull 1st/2nd similiar question...

here whole statement part:

(the problem didn't mention - ''word/number'' part additional included in global single quotation marks - please @ beginning , end of whole 2nd statement...)

select column_name table_name column_name in ('a' , 'st9u' ,'meyer', ....);     vpl_sql_string :=      '     select   b.mview_name   -- use         all_objects@'|| pi_2 ||'         -- master_site             ,user_mviews                    b   -- slave_site             ,user_mview_detail_relations    c   -- slave_site        a.object_type in ' 'table'', ''materialized vie3w'   ')         ,  a.owner        =   upper( :bi_1 )         ,  a.object_name  = c.detailobj_name         ,  b.mview_name   = c.mview_name         , (                 b.refresh_method = ''complete''             or                 (                     b.refresh_method    = ''force''                 , b.last_refresh_type = ''complete''                 )             )         ,  to_date(a.timestamp,''yyyy-mm-dd:hh24:mi:ss'') > b.last_refresh_date   '         || vppgc_sql_string_master_link || ' :bi_2 )    '  ; 

conditions (stay same in):

replace characters in notepad++ exclude characters inside single quotation marks(2nd)

(it's enough, when whole 2nd statement not touched regex! regex don't have exchange values between "global single quotation marks"!)

how can exclude in notepad++ single quotation marks part (from replacement)?

the correct solution question is/was alraedy correct answered @jonny 5 - solution correct whole 2nd statement ( confused...)

replace characters in notepad++ exclude characters inside single quotation marks(2nd)