Useful method from Apache Commons: org.apache.commons.lang.StringUtils.isBlank(String str) https://commons.apache.org/proper/commons-lang/javadocs/api-2.6/org/apache/commons/lang/StringUtils.html#isBlank(java.lang.String)
Rowan Miller (program manager for Entity Framework at Microsoft) recently posted a good solution to this which uses Interceptors. Admittedly this is only valid in EF 6.1+. His post is about trailing strings in joins, but basically, the solution as applied neatly removes trailing strings from all of the string properties in your models, automatically, … Read more
As documented under The CHAR and VARCHAR Types: All MySQL collations are of type PADSPACE. This means that all CHAR and VARCHAR values in MySQL are compared without regard to any trailing spaces. In the definition of the LIKE operator, the manual states: In particular, trailing spaces are significant, which is not true for CHAR … Read more
QString has two methods related to trimming whitespace: QString QString::trimmed() const Returns a string that has whitespace removed from the start and the end. QString QString::simplified() const Returns a string that has whitespace removed from the start and the end, and that has each sequence of internal whitespace replaced with a single space. If you … Read more
Use a RegExp. Don’t forget to escape special characters. s1 = s1.replace(/~+$/, ”); //$ marks the end of a string // ~+$ means: all ~ characters at the end of a string
emails.Split(‘,’).Select(email => email.Trim()).ToArray()
The solution below works very well for me. Only 4 lines and works with most (all?) characters. Solution: :Trim SetLocal EnableDelayedExpansion set Params=%* for /f “tokens=1*” %%a in (“!Params!”) do EndLocal & set %1=%%b exit /b Test: @echo off call :Test1 & call :Test2 & call :Test3 & exit /b :Trim SetLocal EnableDelayedExpansion set Params=%* … Read more
If you have Oracle 10g, REGEXP_REPLACE is pretty flexible. Using the following string as a test: chr(9) || ‘Q qwer’ || chr(9) || chr(10) || chr(13) || ‘qwerqwer qwerty’ || chr(9) || chr(10) || chr(13) The [[:space:]] will remove all whitespace, and the ([[:cntrl:]])|(^\t) regexp will remove non-printing characters and tabs. select tester, regexp_replace(tester, ‘(^[[:space:]]+)|([[:space:]]+$)’,null) … Read more
The PySpark version of the strip function is called trim Trim the spaces from both ends for the specified string column. Make sure to import the function first and to put the column you are trimming inside your function. The following should work: from pyspark.sql.functions import trim df = df.withColumn(“Product”, trim(df.Product))