Reduce number of white spaces

Question

I need to reduce number of white spaces in large number of files. For example:

tree house      big small like      go down up
         nice good  2323'0'-., 123       1234lk

I want it to be like this:

 tree house big small like go down up nice good  2323'0'-., 123 1234lk

It should go by logic somthing like this but I don't know how to do it: one white space | one or more white spaces | any sign character not whitespace | one whitespace

in Replace section it should be somthing like: one whitespace | &1 | one whitespace

This is some logic but if I knew how to do it I would not ask questions.

Regards, Nebojsa

Something like `\s+(\S+)\s+` -> `" \1 "`? Or `\s{2,}` -> `" "`. — Wiktor Stribiżew, Oct 21 '16 at 08:41

score 0 · Answer 1 · answered Oct 21 '16 at 08:41

0

You need simple regex.

 regexp_replace(str,'\s+',' ','m');

'm' - modification for multiline

answered Oct 21 '16 at 08:41

Michael Piankov

1,989
1
8
19

score 0 · Accepted Answer · answered Oct 21 '16 at 08:46

0

in notepad++

\s{2,}

change to simple space

answered Oct 21 '16 at 08:46

Michał M

618
5
13

This is solution. Simple and perfect. – user3082821 Oct 21 '16 at 08:58

Reduce number of white spaces

2 Answers2