replace

Returns "string_expression1" in which every occurrence of "string_expression2" is replaced by "string_expression3". If you omit the "string_expression3" option, every occurrence of "string_expression2" is omitted from the return string.

Syntax

replace ( string_expression1 , string_expression2 [ ,
 string_expression3 ] )

Example

replace ( [Sales (query)].[Products].[Product line code] , - )

Result

Returns all product line codes without the character "-"