Dataport Exports - formatting a numeric field

Business Central/NAV User Forum
1

Hi everyone,

I have written a dataport to export info into a txt file. The issue I am having is that when exporting numeric fields e.g. 1000, the dataport writes the field as 1,000. I need to reformat this field to remove the comma. Does anyone have any ideas on how I can achieve this?

Regards, Sue Miller

2

Hi Miller

Create a variable in the dataport for example

Variable1 with integer data type

Select Variable1 as your dataport field (You cannot select you have to enter it manualy)Now place the bleow code at OnBeforeExportRecord() trigger of the data port

Variable1:=( DIV 1); (Field name is your data item field)

Now run and export.

Thanks

Jerome Marshal.J

3

Marshall,

Thanks for the feedback - I will give it a go over the weekend.

Sue

4

You may also format the dataport-field itself; select properties for that field and in the format-line you enter “”.

5

Thanks for pointing me in the right direction.

I had to set the properties format to <Standard Format, 1> to get this to work (which is equivalent to )

Sue