Remove field delimiters in Dataport

Roelof

Hi,

Is there a way to remove field delimiters in a dataport? I want to export a file without fielddelimiters and only with commas between fields, as a comma-separated file (so that I can read the file Excel).
If I try to delete them in the dataport property settings, it comes back up as a default value.

Thanks.

Jaana

Hi,

just use <None> (case sensitive!!!) as FieldStartDelimiter and FieldEndDelimiter. As FieldSeparator use the default <,>.

Cheers,
Jaana

DenSter

I'd use <TAB> as field separator, because many times descriptions have commas as part of the value. Tab delimited files can also be read into Excel.