Jigsaw Blog

30

Mar
2011
0 comments

Create a CSV file via an XMLport with no field delimiter

You are trying to create a CSV file in NAV 2009 using an XMLPort, but you want no field delimiter.

When you try to enter a blank in the field "FieldDelimiter" it keeps defaulting to <">

It turns out that unlike most other NAV fields, you can validly enter text between the < >

If you enter <None> it works!

See below

Value Description
<None> There is no FieldEndDelimiter
<NewLine> Any combination of CR and LF characters
<CR/LF> CR followed by LF
<CR> CR alone
<LF> LF alone
<TAB> Tabulator alone
Other strings The literal string entered