Comma in Dataport

upasanisandip
upasanisandip Member Posts: 405
edited 2007-12-18 in NAV/Navision Classic Client
Hi all,
While importing data from .csv file, for the address field of Customer Card comma is there, so it is creating problem.
How can this be solved?

thanks,
sandip.

Comments

  • ssingla
    ssingla Member Posts: 2,973
    Change the field seprator in the dataport to something other than " , ".
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Alisha
    Alisha Member Posts: 217
    If you save the csv from Excel, and it does contain a comma, the contents of that field are saved between "", so it wouldn't cause a problem to import it using a dataport with field separator = ','.

    I'm doing that and it works fine.
  • kolaboy
    kolaboy Member Posts: 446
    The safest is to change the FieldStartDelimiter and FieldEndDelimiter to none and then import. Its going to complain of commas if you don't take care of the commas. Make sure there is no comma in you data.
  • Alisha
    Alisha Member Posts: 217
    kolaboy wrote:
    The safest is to change the FieldStartDelimiter and FieldEndDelimiter to none and then import. Its going to complain of commas if you don't take care of the commas. Make sure there is no comma in you data.

    That's not true, I'm importing data with commas separated by commas too (csv files), and it works perfectly.
  • kolaboy
    kolaboy Member Posts: 446
    What you said is true, I am just suggesting that if he is having trouble with the comma delimited, then he can do what i said.

Categories