Exporting text: Replacing commas in numbers

Cannikin
Cannikin Member Posts: 72
edited 2005-04-19 in NAV/Navision Classic Client
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!

Comments

  • aleix1979
    aleix1979 Member Posts: 213
    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)
    Navision Developer
  • Kowa
    Kowa Member Posts: 927
    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.
    Kai Kowalewski
  • Cannikin
    Cannikin Member Posts: 72
    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
    ARPaul Member Posts: 10
    If you are exporting to Excel, try www.print2excel.com. You don't have to worry about all of that comma-delimited stuff.

Categories