What is difference between ValueSeparator and ValueDelimiter

Mar 10, 2014 at 5:46 AM
Can u please explain me what is difference between ValueSeparator and ValueDelimiter

if the value in csv file column like "YEAR;2014;;;"
Coordinator
Mar 11, 2014 at 1:14 AM
Hi,

It's all in the docs, but the separator separates distinct values whilst a delimiter demarcates them if the value contains the delimiter. In your data example, ';' is the separator and you do not have any need for a delimiter. If you had values that contained ';', then you would need a delimiter. eg:

YEAR;2014;"foo;bar";

In this case, '"' would be your delimiter.

Cheers,
Kent