blocks|key|1105763|text|您需要：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1105764|$ro+=+preg_replace('/\s%2B/',+'+',+$row['message']);|code-block|syntax|javascript|1105765|您正在使用\s\s%2B，它表示空格(空格、制表符或换行符)后跟一个或多个空格。这实际上意味着用一个空格替换两个或多个空格。|offset|length|style|CODE|1105766|您想要的是用单个空格替换一个或多个空格，这样您就可以使用模式\s\s*或\s%2B+(推荐)|1105767|entityMap^0|0|0|5|5|0|U|5|10|3|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@$I|W|J|X|K|L]|$I|Y|J|Z|K|L]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|P|$]]

You need:
<pre><code>$ro = preg_replace('/\s+/', ' ', $row['message']);
</code></pre>
You are using <code>\s\s+</code> 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 <code>\s\s*</code> or <code>\s+</code> (recommended)

blocks|key|1105796|text|<?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";
?>|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1105797|下面的输出|unstyled|1105798|This+is++a+string+++with
spaces,+tabs+and+newlines+present
---
This+is+a+string+with+spaces,+tabs+and+newlines+present|1105799|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>&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;
</code></pre>

This outputs

<pre class="lang-none prettyprint-override"><code>This is a string with
spaces, tabs and newlines present
---
This is a string with spaces, tabs and newlines present
</code></pre>

blocks|key|1321004|text|preg_replace('/[\s]%2B/mu',+'+',+$var);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1321005|\s已经包含了制表符和新行，所以上面的正则表达式似乎就足够了。|unstyled|offset|length|style|CODE|1321006|entityMap^0|0|0|2|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>preg_replace('/[\s]+/mu', ' ', $var);
</code></pre>

<code>\s</code> already contains tabs and new lines, so this above regex appears to be sufficient.

blocks|key|1106051|text|简化为一个函数：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1106052|function+removeWhiteSpace($text)
{
++++$text+=+preg_replace('/[\t\n\r\0\x0B]/',+'',+$text);
++++$text+=+preg_replace('/([\s])\1%2B/',+'+',+$text);
++++$text+=+trim($text);
++++return+$text;
}|code-block|syntax|javascript|1106053|基于Danuel+O‘’Neal的回答。|1106054|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

simplified to one function:

<pre><code>function removeWhiteSpace($text)
{
 $text = preg_replace('/[\t\n\r\0\x0B]/', '', $text);
 $text = preg_replace('/([\s])\1+/', ' ', $text);
 $text = trim($text);
 return $text;
}
</code></pre>

based on Danuel O'Neal answer.

blocks|key|1320747|text|$str='This+is+++a+Text+\n+and+so+on+Text+text.';
print+preg_replace("/[[:blank:]]%2B/","+",$str);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1320748|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$str='This is a Text \n and so on Text text.';
print preg_replace("/[[:blank:]]+/"," ",$str);
</code></pre>

blocks|key|1105851|text|preg_replace('/(\s\s%2B%7C\t%7C\n)/',+'+',+$row['message']);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1105852|这会将所有制表符、所有换行符以及多个空格、制表符和换行符的所有组合替换为一个空格。|unstyled|1105853|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>preg_replace('/(\s\s+|\t|\n)/', ' ', $row['message']);
</code></pre>

This replaces all tabs, all newlines and all combinations of multiple spaces, tabs and newlines with a single space.

blocks|key|1105900|text|<?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
#+%2B++++//+one+or+more

class+whitespace{

++++static+function+remove_doublewhitespace($s+=+null){
+++++++++++return++$ret+=+preg_replace('/([\s])\1%2B/',+'+',+$s);
++++}

++++static+function+remove_whitespace($s+=+null){
+++++++++++return+$ret+=+preg_replace('/[\s]%2B/',+'',+$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);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1105901|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>&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);
</code></pre>

blocks|key|1106027|text|不使用preg_replace()|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1106028|$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;|code-block|syntax|javascript|1106029|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Without preg_replace()

<pre><code>$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;
</code></pre>

blocks|key|1320906|text|这就是我要用到的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1320907|a.请确保使用双引号，例如：|1320908|$row['message']+=+"This+is+++a+Text+\n+and+so+on+\t+++++Text+text.";|code-block|syntax|javascript|1320909|b.要删除多余的空格，请使用：|1320910|$ro+=+preg_replace('/\s%2B/',+'+',+$row['message']);+
echo+$ro;|1320911|这可能不是最快的解决方案，但我认为它需要最少的代码，而且应该可以工作。不过，我从来没有使用过mysql，所以我可能错了。|1320912|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

This is what I would use:

a. Make sure to use double quotes, for example:

<pre><code>$row['message'] = "This is a Text \n and so on \t Text text.";
</code></pre>

b. To remove extra whitespace, use:

<pre><code>$ro = preg_replace('/\s+/', ' ', $row['message']); 
echo $ro;
</code></pre>

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.

blocks|key|1320792|text|您所需要的就是按如下方式运行它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1320793|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.|code-block|syntax|javascript|1320794|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

All you need is to run it as follows:

<pre><code>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.
</code></pre>

blocks|key|1105921|text|我使用以下代码和模式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1105922|preg_replace('/\\s%2B/',+'+',$data)

$data+=+'This+is+++a+Text+
+++and+so+on+++++++++Text+text+on+multiple+lines+and+with++++++++whitespaces';
$data=+preg_replace('/\\s%2B/',+'+',$data);
echo+$data;|code-block|syntax|javascript|1105923|您可以在http://writecodeonline.com/php/上进行测试|offset|length|1105924|entityMap|0|LINK|mutability|MUTABLE|url|http://writecodeonline.com/php/^0|0|0|4|V|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

I use this code and pattern:

<pre><code>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;
</code></pre>

You may test this on <a href="http://writecodeonline.com/php/" rel="nofollow">http://writecodeonline.com/php/</a>

blocks|key|1321035|text|说实话，如果你想要这样的东西：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1321036|preg_replace('/\n%2B%7C\t%2B%7C\s%2B/','+',$string);|code-block|syntax|javascript|1321037|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

On the truth, if think that you want something like this:

<pre><code>preg_replace('/\n+|\t+|\s+/',' ',$string);
</code></pre>

blocks|key|1106012|text|这将用单个选项卡替换多个选项卡|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1106013|preg_replace("/\s{2,}/",+"\t",+$string);|code-block|syntax|javascript|1106014|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

this will replace multiple tabs with a single tab 

<pre><code>preg_replace("/\s{2,}/", "\t", $string);
</code></pre>

blocks|key|1106076|text|没有preg_replace，在循环的帮助下。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1106077|<?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+<+$str_length;+$i%2B%2B)+{
++++if+(isset($str_arr[$i+%2B+1])
+++++++&&+$str_arr[$i]+==+'+'
+++++++&&+$str_arr[$i]+==+$str_arr[$i+%2B+1])+{
+++++++unset($str_arr[$i]);
++++}+
++++else+{
++++++continue;
++++}
}

+echo+implode("",+$str_arr)+;+

+?>|code-block|syntax|javascript|1106078|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Without preg_replace, with the help of loop.

<pre><code>&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;
</code></pre>

I'm getting <code>$row['message']</code> from a MySQL database and I need to remove all whitespace like <code>\n</code> <code>\t</code> and so on.

<pre><code>$row['message'] = "This is a Text \n and so on \t Text text.";
</code></pre>

should be formatted to:

<pre><code>$row['message'] = 'This is a Text and so on Text text.';
</code></pre>

I tried:

<pre><code> $ro = preg_replace('/\s\s+/', ' ',$row['message']);
 echo $ro;
</code></pre>

but it doesn't remove <code>\n</code> or <code>\t</code>, just single spaces. Can anyone tell me how to do that?

Remove multiple whitespaces

SQL数据库

数据库

MySQL

我要从MySQL数据库中获取$row['message']，需要删除所有空格，如\n、\t等。$row['message'] = "This is   a Text \n and so on \t     Text text.";应格式化为：$row['message'] = 'This is a Text and so on Text text.';我试过了： $ro = preg_replac

问删除多个空格
EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问删除多个空格EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问删除多个空格
EN