Avoid FieldStartDelimiter for the first field in a record fo

JEyton
JEyton Member Posts: 33
edited 2007-12-05 in NAV/Navision Classic Client
I am creating a dataport for the record “Sales Header” and “Sales Line”. The export file should be as the following text:

1,"2404","","2001/01/02",92,2295.30,"21:27:13","2007/11/08",
2,"131522373","XXXXX",2,88.2,"2001/01/02",
2,"1315","XXXX",1,179.05,"2001/01/02",

The hard thing is the first field in each record, which should not have the “ FieldStartDelimiter or FieldEndDelimiter.

Is there any way to solve this?

Comments

  • seapcrs
    seapcrs Member Posts: 5
    Field start and end delimiters are only necessaries working in variable format (records to export/import).

    Using the Fixed format, you don't need them.

    It's ok for you?
  • Malajlo
    Malajlo Member Posts: 294
    If your line is not longer than 1024 chars, you can compose line and write directly into file.
    txt := Code+',"'+format(Date)+'",'+ ....;
TextFile.WRITE(txt) ;
  • JEyton
    JEyton Member Posts: 33
    Thanks for your replies. The solution I did was to set the fieldstartdelimiter and fieldenddelimiter to None.

    On the fields that required " I used the following code in the source expr for the fields

    '"' + "No." + '"'

    Problem solved

Categories