You’re looking for TRIM. UPDATE FOO set FIELD2 = TRIM(FIELD2); Seems like it might be worth it to mention that TRIM can support multiple types of whitespace, but only one at a time and it will use a space by default. You can, however, nest TRIMs. TRIM(BOTH ‘ ‘ FROM TRIM(BOTH ‘\n’ FROM column)) If … Read more
String.Trim() returns a string which equals the input string with all white-spaces trimmed from start and end: ” A String “.Trim() -> “A String” String.TrimStart() returns a string with white-spaces trimmed from the start: ” A String “.TrimStart() -> “A String ” String.TrimEnd() returns a string with white-spaces trimmed from the end: ” A String … Read more
A simple possibility (if you’d rather avoid REs) is ‘ ‘.join(mystring.split()) The split and join perform the task you’re explicitly asking about — plus, they also do the extra one that you don’t talk about but is seen in your example, removing trailing spaces;-).
Add a \s? if a space can be allowed. \s stands for white space ? says the preceding character may occur once or not occur. If more than one spaces are allowed and is optional, use \s*. * says preceding character can occur zero or more times. ‘#<a href\s?=”https://stackoverflow.com/questions/14293024/(.*?)” title\s?=”https://stackoverflow.com/questions/14293024/(.*?)”><img alt\s?=”https://stackoverflow.com/questions/14293024/(.*?)” src\s?=”https://stackoverflow.com/questions/14293024/(.*?)”[\s*]width\s?=”150″[\s*]height\s?=”https://stackoverflow.com/questions/14293024/(.*?)”></a>#’ allows an optional … Read more
This is fastest way I know of, even though you said you didn’t want to use regular expressions: Regex.Replace(XML, @”\s+”, “”); Crediting @hypehuman in the comments, if you plan to do this more than once, create and store a Regex instance. This will save the overhead of constructing it every time, which is more expensive … Read more
As of R 3.2.0 a new function was introduced for removing leading/trailing white spaces: trimws() See: Remove Leading/Trailing Whitespace
You’re seeing the space for descenders (the bits that hang off the bottom of ‘y’ and ‘p’) because img is an inline element by default. This removes the gap: .youtube-thumb img { display: block; }
If you want to remove leading and ending spaces, use str.strip(): >>> ” hello apple “.strip() ‘hello apple’ If you want to remove all space characters, use str.replace() (NB this only removes the “normal” ASCII space character ‘ ‘ U+0020 but not any other whitespace): >>> ” hello apple “.replace(” “, “”) ‘helloapple’ If you … Read more