DataFlow.StrReplace(ColumnsSelector, String, String, Boolean, Boolean) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Replaces values in a string column that match a search string with the specified value.
public Microsoft.DataPrep.Common.DataFlow StrReplace(Microsoft.DPrep.Engine.PropertiesSystem.ColumnsSelector columns, string valueToFind = null, string replaceWith = null, bool matchEntireCellContents = false, bool useSpecialCharacters = false);member this.StrReplace : Microsoft.DPrep.Engine.PropertiesSystem.ColumnsSelector * string * string * bool * bool -> Microsoft.DataPrep.Common.DataFlowPublic Function StrReplace (columns As ColumnsSelector, Optional valueToFind As String = null, Optional replaceWith As String = null, Optional matchEntireCellContents As Boolean = false, Optional useSpecialCharacters As Boolean = false) As DataFlowParameters
- columns
- Microsoft.DPrep.Engine.PropertiesSystem.ColumnsSelector
The source columns.
- valueToFind
- String
The value to find.
- replaceWith
- String
The replacement value.
- matchEntireCellContents
- Boolean
Whether the value to find must match the entire value.
- useSpecialCharacters
- Boolean
If checked, you can use '#(tab)', '#(cr)', or '#(lf)' to represent special characters in the find or replace arguments.