DataFlow.ParseDelimited Method

Definition

Return a DataFlow object which can parse data with a specified delimiter.

public Microsoft.DataPrep.Common.DataFlow ParseDelimited(char delimiter = ',', Microsoft.DataPrep.Common.PromoteHeadersMode header = Microsoft.DataPrep.Common.PromoteHeadersMode.SameAllFiles, Microsoft.DPrep.Engine.FileEncoding encoding = Microsoft.DPrep.Engine.FileEncoding.UTF8, bool quoting = false, long skipRows = 0, Microsoft.DataPrep.Common.SkipMode skipMode = Microsoft.DataPrep.Common.SkipMode.None, Nullable<char> commentLineChar = null);
member this.ParseDelimited : char * Microsoft.DataPrep.Common.PromoteHeadersMode * Microsoft.DPrep.Engine.FileEncoding * bool * int64 * Microsoft.DataPrep.Common.SkipMode * Nullable<char> -> Microsoft.DataPrep.Common.DataFlow

Parameters

delimiter
Char

The separator to use to split columns. Default is comma.

header
PromoteHeadersMode

How to determine column headers.

encoding
Microsoft.DPrep.Engine.FileEncoding

The encoding of the files being read.

quoting
Boolean

Whether to handle new line characters within quotes. This option will impact performance.

skipRows
Int64

How many rows to skip.

skipMode
SkipMode

The mode in which rows are skipped.

commentLineChar
Nullable<Char>

Character used to indicate a line is a comment instead of data in the files being read.

Returns

A new Dataflow with Parse Delimited Step added.

Applies to