Forum Discussion
2 Replies
- SupportNoteGuyMYOB Staff
Hi Milspares - sorry for the late reply!
This is certainly an odd one! You can either:
- edit the items one by one (the slow solution)
- export the items with inverted commas and remove them (using Excel), then import them back (the quick solution)
- Mike_JamesUltimate Partner
Hi Milspares , this has happened because of the commas and apostrophes in those codes & names, which were probably imported via a text file at some stage. Whilst you can export/reimport a text file and change item names, you cannot change item codes that way, AccountRight will treat it as a new item, so you'll end up with a duplicate set of items.
Since there are not that many, edit them all manually.
When importing those kind of values, edit the text file before you import it, and remove all the apostrophes. But you'll need to be careful with that, as you will want to keep the apostrophes for the inch symbol. My solution for that:
- In excel, change all the " to a unique value, eg &&
- Before importing, edit the text file, remove all the " values, then replace all && with ".
- Save and import
When importing, take a backup beforehand in case of trouble.