Removes leading and trailing quotes or double-quotes from a string. Quote marks in the middle of the string are not removed.

Column reference example:

trimquotes(MyName)

Output: Returns the values of the MyName column value with any quotes removed from the beginning and the end. 

String literal examples:

NOTE: For string literal values that contain quotes to remove, you can bracket them in the quote mark of a different type. Some examples are below.

trimquotes('"Hello, World"')

Output: Input string is "Hello, World". Output of the function is the string: Hello, World.

trimquotes('""Hello,\" World""')

Output: Input string is ""Hello,\" World"". Output of the function is the string: Hello," World.

Following input contains a single whitespace at the beginning and end of the string, which is the same as the previous string. To clean, you can first remove the whitespace with the TRIM function. 

trimquotes(trim((' ""Hello,\" World"" ')))

Output: Input string is  ""Hello,\" World"" . Output of the function is the string: Hello," World. See TRIM Function.

trimquotes(column_string)


ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function

column_string

Name of the column or string constant whose beginning and end quote marks are to be trimmed.

Required?Data TypeExample Value
YesString literal or column referencemyColumn

Example - String whitespace and quotes

The following example data contains a mixture of quotes and spaces strings. You can use the transformation listed below to clean up leading and trailing quotes and strings in a single transformation. 

Source:

StringDescription
My String"Base string: ""My String"""
My String extra"Base string + "" extra"""
 My StringA space in front of base string
My String A space after base string
MyStringNo space between the two words of base string
My  StringTwo spaces between the two words of base string
"My String "Base string + a tab character
"My String
"
Base string + a return character
"My String
"
Base string + a newline character


Transformation:

You can use the following transformation which nests the TRIM and the TRIMQUOTES functions to clean up all of the columns in your dataset.

Results:

StringDescription
My StringBase string: ""My String
My String extraBase string + "" extra
My StringA space in front of base string
My StringA space after base string
MyStringNo space between the two words of base string
My  StringTwo spaces between the two words of base string
My StringBase string + a tab character
My StringBase string + a return character
My StringBase string + a newline character