Remove multiple whitespaces

Question

I m getting  row  message   from a MySQL database and I need to remove all whitespace like  n  t and so on    row  message      This is   a Text  n and so on  t     Text text      should be formatted to    row  message      This is a Text and so on Text text      I tried     ro   preg replace    s s          row  message      echo  ro    but it doesn t remove  n or  t  just single spaces  Can anyone tell me how to do that

User · Answer

I use this code and pattern   preg replace     s          data    data    This is   a Text     and so on         Text text on multiple lines and with        whitespaces    data  preg replace     s          data   echo  data    You may test this on http   writecodeonline com php

User · Answer

This is what I would use   a  Make sure to use double quotes  for example    row  message      This is   a Text  n and so on  t     Text text      b  To remove extra whitespace  use    ro   preg replace    s           row  message      echo  ro    It may not be the fastest solution  but I think it will require the least code  and it should work  I ve never used mysql  though  so I may be wrong

User · Answer

this will replace multiple tabs with a single tab      preg replace    s 2        t    string

User · Answer

str  This is   a Text  n and so on Text text    print preg replace      blank            str

User · Answer

All you need is to run it as follows   echo preg replace    s 2            This is   a Text  n and so on  t     Text text        This is a Text and so on Text text

User · Answer

Without preg replace  with the help of loop    lt  php   str    This is   a Text  n and so on  t     Text text     str length   strlen  str    str arr   str split  str   for   i   0   i  lt   str length   i          if  isset  str arr  i   1           amp  amp   str arr  i                 amp  amp   str arr  i      str arr  i   1            unset  str arr  i               else         continue            echo implode      str arr         gt

User · Answer

preg replace     s   mu         var      s already contains tabs and new lines  so this above regex appears to be sufficient

User · Answer

I can t replicate the problem here    x    this     n  t t  n    works    var dump preg replace    s s           x       string 11   this works     I m not sure if it was just a transcription error or not  but in your example  you re using a single-quoted string   n and  t are only treated as new-line and tab if you ve got a double quoted string  That is     n t       n t    Edit  as Codaddict pointed out   s s  won t replace a single tab character  I still don t think using  s  is an efficient solution though  so how about this instead   preg replace       s s   n  t           x

User · Answer

On the truth  if think that you want something like this   preg replace    n   t   s         string

User · Answer

preg replace     s s   t  n           row  message       This replaces all tabs  all newlines and all combinations of multiple spaces  tabs and newlines with a single space

User · Answer

You need    ro   preg replace    s          row  message       You are using  s s  which means whitespace space  tab or newline  followed by one or more whitespace  Which effectively means replace two or more whitespace with a single space    What you want is replace one or more whitespace with single whitespace  so you can use the pattern   s s  or  s   recommended

User · Answer

lt  php  This should help some newbies   REGEX NOTES FROM DANUEL   I wrote these functions for my own php framework   Feel Free to make it better   If it gets more complicated than this  You need to do more software engineering logic            capture any character    1      if it is followed by itself           one or more  class whitespace       static function remove doublewhitespace  s   null              return   ret   preg replace      s   1           s              static function remove whitespace  s   null              return  ret   preg replace     s           s               static function remove whitespace feed   s   null              return  ret   preg replace     t n r 0 x0B          s              static function smart clean  s   null              return  ret   trim  self  remove doublewhitespace  self  remove whitespace feed  s                string     Hey   yo  what s  t n tthe sc r nen n tario   n   echo whitespace  smart clean  string

User · Answer

lt  php  str    This is  a string       with spaces  tabs and newlines present     stripped   preg replace array    s 2          t n            str    echo  str  echo   n--- n   echo   stripped     gt    This outputs  This is  a string   with spaces  tabs and newlines present --- This is a string with spaces  tabs and newlines present

User · Answer

Without preg replace     str    This is   a Text  n and so on  t     Text text     str   str replace    r     n     t          str   while  strpos  str            false         str   str replace             str     echo  str

User · Answer

simplified to one function   function removeWhiteSpace  text         text   preg replace     t n r 0 x0B          text        text   preg replace      s   1           text        text   trim  text       return  text      based on Danuel O Neal answer

[php] Remove multiple whitespaces

Examples related to php

Examples related to regex

Examples related to string

Examples related to preg-replace

Examples related to whitespace