Forum Discussion

nduro's avatar
nduro
Experienced User
5 years ago

Importing Items with Commas anywhere in description automatically adding Quotation marks " " at both ends of the description.

Hi,   Whenever we import item data that has a comma , anywhere in the decription text, Myob is automatically adding " " Quotation marks at both ends of the description text.   Can this be avoided...
  • gavin12345's avatar
    gavin12345
    5 years ago

    Hi nduro 

     

    Its not MYOB that adds these, check your import file using Notepad. You will find if you use a spreadsheet program like excel, when you save as a text format (whether tab delimited or CSV) excel adds the quote marks to ensure the cell contents stay together.

     

    So after you create the import file, open in notepad and replace all quote marks with nothing, that should work.

     

    Regards

    Gavin

gavin12345's avatar
gavin12345
Ultimate User
5 years ago

Hi nduro 

 

Its not MYOB that adds these, check your import file using Notepad. You will find if you use a spreadsheet program like excel, when you save as a text format (whether tab delimited or CSV) excel adds the quote marks to ensure the cell contents stay together.

 

So after you create the import file, open in notepad and replace all quote marks with nothing, that should work.

 

Regards

Gavin

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.