By using an OR operator, you can specify multiple record delimiters in the metadata.
In the Edge metadata, the default record delimiter for a file depends on which operating system was used to create the file. For example, the default record delimiter for a Windows file is \r\n, while \n is typically used for Linux files.
However, you may have files that were created on different platforms
(for example, if you have input files that you check out of a version control
system, the files' line endings will vary according to the platform). In this
case, you would want the record delimiter to be set to both values, so that you
could use the same graph on Windows or Linux. You would then set the record
delimiter to:
\r\n\\|\n
The | (pipe) character is an OR operator and the \\| syntax is a way to escape that OR operator in the Integrator interface.
To specify multiple record delimiters in the metadata:
-
In the Record pane of the Metadata Editor, click the first row
(the Record row).
In this example, you would click the Record:ProductCategory row.
-
In the Details pane (to the right of the Record pane), check the
Record delimiter property to see the default
setting.
In this example, \r\n is set as the record delimiter.
-
Place the cursor in the Value field of the
Record delimiter property, and select
\r\n\\|\n from the drop-down menu.
The Details pane should now look like this:
