Forum Discussion

patricko's avatar
patricko
Contributing User
6 years ago

Importing Quotation Marks

I have exported my items out of accountright and then alter the prcing in excel and save as a text tab delimited .txt file. When I then import back into myob everything looks good except for all the ...
  • Mike_James's avatar
    Mike_James
    6 years ago

    Hi patricko , this happens because the field name contains a comma, which 'obliges' Excel to add quotes around it when saving.

     

    The easiest solution is to edit the file as it is being imported (ie when you browse for the text file, right-click, choose Edit, then in the editor, choose Edit, Replace, and replace all quotes with nothing - assuming there are no quotes anywhere else in your file, if there are you need to replace one at a time). Then close the file, save it, and contrinue with your import. 

Mike_James's avatar
Mike_James
Ultimate Cover User
6 years ago

Hi patricko , this happens because the field name contains a comma, which 'obliges' Excel to add quotes around it when saving.

 

The easiest solution is to edit the file as it is being imported (ie when you browse for the text file, right-click, choose Edit, then in the editor, choose Edit, Replace, and replace all quotes with nothing - assuming there are no quotes anywhere else in your file, if there are you need to replace one at a time). Then close the file, save it, and contrinue with your import. 

  • patricko's avatar
    patricko
    Contributing User
    6 years ago

    Thank you

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.