Forum Discussion

patricko's avatar
patricko
Contributing User
6 years ago
Solved

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

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

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

 

Related content