Menu
Community /Pin to ProfileBookmark
@NogDogSep 13.2020 — #It might be easier to tell us exactly what you're trying to accomplish here -- and perhaps _why_, as well. Then we can help you decide if a regex approach is the best way, and if so, recommend the right search string. (I don't see why that pattern would include newlines (
Again: why? MySQL character and text fields can handle "special characters" just fine. If Conan O'Brien and Catherine Zeta-Jones register for your site, are you going to store their last names as
Anyway, it's going to get messy. You probably want tabs to be converted to spaces, while things like quotes just get stripped out, so you may need to do two replacement passes on it (one converting certain characters to a space, and another to convert other characters to an empty string). This may be too aggressive, but...?
Regular expression takes also newline character but not specified
Dear users,
I have a string containing various characters. From that string I want to remove some characters like tabs and quotes.
I use this php code:
“`
<?
$str = ‘RegExr was created by gskinner.com, and is proudly hosted by Media Temple.
Edit the Expression & Text to see matches. Roll over matches or the expression for details. PCRE & JavaScript flavors of RegEx are supported. Validate your expression with Tests mode.
The side bar includes a Cheatsheet, full Reference, and Help. You can also Save & Share with the Community, and view patterns you create or favorite in My Patterns.
Explore results with the “Tools below. Replace & List output” custom results. Details’ lists capture groups. Explain des’cribes your expression in plain English.’;
echo preg_replace(‘/[cItvf”\’]/’, ”, $str);
?>
I created a draft on regexr at this link:
On that website, the newline character, not specified in regular expression, is left there. But in my php function, it is removed.
I don’t want to remove newline character from the string.
How can I fix?
Thanks
Sign in
to post a comment7 Comments(s) ↴
0
@NogDogSep 13.2020 — #It might be easier to tell us exactly what you're trying to accomplish here -- and perhaps _why_, as well. Then we can help you decide if a regex approach is the best way, and if so, recommend the right search string. (I don't see why that pattern would include newlines (n0
@NogDogSep 14.2020 — #>@redagr#1623265 I want to remove single and double quotes, tab and other similar characters from a string to store in a mysql table.
Again: why? MySQL character and text fields can handle "special characters" just fine. If Conan O'Brien and Catherine Zeta-Jones register for your site, are you going to store their last names as
"OBrien""ZetaJones""O Brien""Zeta Jones"Anyway, it's going to get messy. You probably want tabs to be converted to spaces, while things like quotes just get stripped out, so you may need to do two replacement passes on it (one converting certain characters to a space, and another to convert other characters to an empty string). This may be too aggressive, but...?
<i>
</i>$filtered_text = preg_replace('/t/', ' ', $text); // tabs -> spaces
$filtered_text = preg_replace('/[^sw]/', '', $filtered_text); // remove non-white-space, non-word characters