Cannot use | (pipe) as a separator in Dataprep

Overview

The | (pipe) separator does not work in Dataprep. Dataprep does not recognize | as a separator. It loads the whole record in one field. Trying to manually set the separator does not work either.

 

Environment

Version 1.2

 

Symptoms/Description

When loading a data file, DataPrep does not detect the '|' as a data separator in a text file with the text fields enclosed with " (quotation marks).

 

Even after trying to manually set the separator using the Edit dataset parameters button and specifying '|' (tried with double quotes, single quotes, on its own and escaped, and combinations of these) it will still load the entire row as a single field. Changing the character set has no effect.

 

A row like this:
"field1"|"field2"

is loaded into a single column as:

field1"|"field2

 

Resolution

Changing the separator to a "," (comma) loads the data correctly.

Version history
Revision #:
2 of 2
Last update:
‎06-20-2017 08:18 PM
Updated by:
 
Labels (1)
Contributors
Tags (1)