[jira] [Commented] (SPARK-25967) sql.functions.trim() should remove trailing and leading tabs
[ https://issues.apache.org/jira/browse/SPARK-25967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16679083#comment-16679083 ] Victor Sahin commented on SPARK-25967: -- I see. In that case I can close the issue. > sql.functions.trim() should remove trailing and leading tabs > > > Key: SPARK-25967 > URL: https://issues.apache.org/jira/browse/SPARK-25967 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.1.0, 2.2.0, 2.3.2 >Reporter: Victor Sahin >Priority: Minor > > sql.functions.trim removes only trailing and leading whitespaces. Removing > tabs as well helps use the function for the same use case e.g. artifact > cleaning. -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-25967) sql.functions.trim() should remove trailing and leading tabs
[ https://issues.apache.org/jira/browse/SPARK-25967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16678700#comment-16678700 ] kevin yu commented on SPARK-25967: -- Hello Victor: I see, by SQL2003 standard, the TRIM function removes spaces by default. > sql.functions.trim() should remove trailing and leading tabs > > > Key: SPARK-25967 > URL: https://issues.apache.org/jira/browse/SPARK-25967 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.1.0, 2.2.0, 2.3.2 >Reporter: Victor Sahin >Priority: Minor > > sql.functions.trim removes only trailing and leading whitespaces. Removing > tabs as well helps use the function for the same use case e.g. artifact > cleaning. -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-25967) sql.functions.trim() should remove trailing and leading tabs
[ https://issues.apache.org/jira/browse/SPARK-25967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16678657#comment-16678657 ] Victor Sahin commented on SPARK-25967: -- That is not very intuitive to manually specify especially for the default use when let's say someone is mining text and wants to get rid of any and all blank characters surrounding a substring > sql.functions.trim() should remove trailing and leading tabs > > > Key: SPARK-25967 > URL: https://issues.apache.org/jira/browse/SPARK-25967 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.1.0, 2.2.0, 2.3.2 >Reporter: Victor Sahin >Priority: Minor > > sql.functions.trim removes only trailing and leading whitespaces. Removing > tabs as well helps use the function for the same use case e.g. artifact > cleaning. -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-25967) sql.functions.trim() should remove trailing and leading tabs
[ https://issues.apache.org/jira/browse/SPARK-25967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16678614#comment-16678614 ] kevin yu commented on SPARK-25967: -- Hello Victor: You can specify the tabs as specified characters to remove in the trim function, the detail syntax is here. https://spark.apache.org/docs/2.3.0/api/sql/#trim > sql.functions.trim() should remove trailing and leading tabs > > > Key: SPARK-25967 > URL: https://issues.apache.org/jira/browse/SPARK-25967 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.1.0, 2.2.0, 2.3.2 >Reporter: Victor Sahin >Priority: Minor > > sql.functions.trim removes only trailing and leading whitespaces. Removing > tabs as well helps use the function for the same use case e.g. artifact > cleaning. -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org