Avoid FieldStartDelimiter for the first field in a record fo

JEyton

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?

seapcrs

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

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

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