Forum Discussion

PF_1's avatar
PF_1
Experienced Cover User
2 years ago
Solved

AccountRight - Imported items - now it has inverted commas in the description? ".........."

I have imported our items list after the price increase - all item descriptions now has inverted commas in the description.  It was not part of our export or import file.  How do I get rid of it?  We...
  • gavin12345's avatar
    gavin12345
    2 years ago

    Hi PF_1 

     

    If you open the import file using notepad - there you will find all the quote marks. Common problem and reason why it is important to do a backup before any import - as you cannot 'undo' and such errors. Options are to change each on onscreen, try to fix via import, or get a myob specialist to fix for you (send me a private message for contact details).

     

    This happens when you use excel to create a tab delimited or comma delimited file. If a field has a comma, such as $1,234.00 or Tom, Jerry - excel will save this as "$1,234.00" and "Tom, Jerry" in order to preserve the comma.

     

    After creating the import file you could use notepad to search and replace all quotes marks with nothing. However this will also remove quote marks you wanted such as '3/4" socket'. There are workarounds however this is a little complicated to explain here.

     

    Regards

    Gavin

gavin12345's avatar
gavin12345
Ultimate User
2 years ago

Hi PF_1 

 

If you open the import file using notepad - there you will find all the quote marks. Common problem and reason why it is important to do a backup before any import - as you cannot 'undo' and such errors. Options are to change each on onscreen, try to fix via import, or get a myob specialist to fix for you (send me a private message for contact details).

 

This happens when you use excel to create a tab delimited or comma delimited file. If a field has a comma, such as $1,234.00 or Tom, Jerry - excel will save this as "$1,234.00" and "Tom, Jerry" in order to preserve the comma.

 

After creating the import file you could use notepad to search and replace all quotes marks with nothing. However this will also remove quote marks you wanted such as '3/4" socket'. There are workarounds however this is a little complicated to explain here.

 

Regards

Gavin

  • PF_1's avatar
    PF_1
    Experienced Cover User
    2 years ago

    Thanks Gavin

    I didn't look in my textfile! I've fixed it now.  Thanks heaps for the solution :)

Related content