Geek Answers Handbook

Replace the number of spaces inside ONE single quotes in notepad ++ against the same number of CHR (32) (2)

I want to replace EVERY space inside single EMPTY quotes against the same CHR (32) number.

condition: REGEX should correspond only to this case - not for cases with signs between single quotes!

important hint: a design where to replace the gaps between them begins in each case with:

\|\|\s*'

and ends (in each case) with (according to line 1 + 2):

'\s*\|\|

I use for the search pattern:

'(\s)+'

and for replacement:

CHR\(32\)

But this replaces all spaces with ONE CHR (32) only!

The following example:

vpl_text := to_char(vpl_text_old) || '    ' ||...;
vpl_text := to_char(vpl_text_old) || '' ||...;
(3)' WHERE   a.object_type IN (' 'TABLE'', ''MATerialIZED VIE3W'   ')  '   
(4) WHERE    a.object_type IN (' 'TABLE'', ''MATerialIZED VIE3W'   ')

my incomplete result:

vpl_text := to_char(vpl_text_old) || CHR(32) ||...;
vpl_text := to_char(vpl_text_old) || '' ||...;
(3)' WHERE   a.object_type IN (CHR(32)TABLE'', ''MATerialIZED VIE3WCHR(32))  '   
(4) WHERE    a.object_type IN (CHR(32)TABLE'', ''MATerialIZED VIE3WCHR(32))

target result:

vpl_text := to_char(vpl_text_old) || CHR(32) || CHR(32) || CHR(32) || CHR(32) ||...;
vpl_text := to_char(vpl_text_old) || '' ||...;
(3)' WHERE   a.object_type IN (' 'TABLE'', ''MATerialIZED VIE3W'   ')  '   
(4) WHERE    a.object_type IN (' 'TABLE'', ''MATerialIZED VIE3W'   ')

3 + 4 !

( "(3)" "(4)" - !).

: ++ BUT (4)

++ REGEX ?

+4
2

\G anchor, , . - :

(?:'|\G(?!^))\s(?=\s*')'?

CHR\(32\). . test regex101.

  • (?: non-capture . ' | :

  • \G(?!^) , . (?!^)\G .

  • \s (?=\s*') '

  • '? ' \G.

-

+3

( Jonny5):

( , , ( Jonny5))

:

(?:\|\|\s*'|\G(?!^))\s(?=\s*')'?

:

\|\| CHR\(32\)
0

More articles:


All Articles