Step 1: Split the rows. In most cases, the first step added to your recipe is a Splitrows transformation, which breaks up the individual rows based on a consistently recognized pattern at the end of each line. Often, this value is a carriage return or a carriage return-new line. These values are written in
|D s lang|
\r\n, respectively. See the example below.
NOTE: The maximum permitted length of any individual record on input is 20 MB.
Step 2: Split the columns. Next, the application attempts to break up individual rows into columns.