Exporting text: Replacing commas in numbers

Cannikin

Hey guys,

I have a really simple situation. I've got a dataport that exports several fields from our Item table. When it outputs prices, there are commas for anything $1000 or more but I need to get rid of those. What's the Navision function to replace text? Thanks!

aleix1979

I would recommend you to always change the "FieldSeparator" and to use bizzare chars (¬) to separate the fields from one to another. Now when you export the file to txt you should only have the ',' within the fiels which you can easly replace in the notepad.

(should be programmable but it doesn't worth the thinking)

Kowa

There is a format property for each field in the dataport field designer where you can choose a desired format (other than the default which differs for the separate country versions). For help on this put the cursor on "Format" and press F1.

Cannikin

Aleix - That's what I'm doing now, I was just hoping to remove that step in the process and have Navision do it directly.

Kowa - That did it! Thanks!!

ARPaul

If you are exporting to Excel, try www.print2excel.com. You don't have to worry about all of that comma-delimited stuff.