Export data in Navision 2009

fabrizioc

Dear all, I'm a new developer with Navision 2009 and I need to modify an existing export function that export data in a txt file.
This function exports all data but, as separator, inserts a <NONE> tag that I'd like to remove or at least customize with a comma or a blank space.

Debugging the function I can't see a part where this tag is added so it's seems something configured as default.
Can someone help me to identify how to perform this modification?

Thank you in advance for your help.
Best regards
Fabrizio

Juha

Use <None> as field delimiter and <TAB> as separator.
like this

postsaurav

Hi,
1. Design The Dataport.
2. Select Properties of Dataport ( Go to Properties by Placing cursor on a Blank line) Shortcut - Shift + F4
3. Have a Look on Property - FieldSeparator and Change it as you want. IF you want Comma(,) seprated then delete the value against this property.

fabrizioc

Thank you postsaurav, your answer is very useful, I've located the configuration, the <NONE> tag is in FieldStartDelimiter and FieldEndDelimiter, is it possible to completely remove both ? If I try to remove them navision replace with a <">. Thank you again for your precious help.
Best regards
Fabrizio

Juha

<"> is the default value for delimiter. Use <None> if you don't want any delimiter.

/Juha

postsaurav

IF you Replace it with Blank Space then how you plan to use this file. Then it will be a single Line of Text.
Just Curious -
I Actually Don't understand what you will be do with a string of text?

fabrizioc

Thank you postsaurav and Juha, perhaps I'm doing something wrong but if I use <None> as Field delimiter the output file contains a <NONE> tag for each field. I'd like to have a TAB as field delimiter is it possible?
Thank you again for your help.
Best regards
Fabrizio

Juha

Use <None> as field delimiter and <TAB> as separator.
like this