Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
May 2020
May 2020
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 or do I have to change any comma symbols in my descriptions to another symbol like a dash - to avoid the Quotation marks appearing.
"100 Custom Printed Appliance Boxes, One (1) Colour "
This used to happen in V19 also.
Thanks
Nathan
Solved! Go to Solution.
May 2020
May 2020
Imports in MYOB generally don't like commas or characters in general. I normally do a find and replace and replace the commas with a space and then import in the data
May 2020
May 2020
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
by
BareBeauty
4 weeks ago
8
215
|
8
|
215
|
||
0
|
79
|
|||
16
|
748
|
|||
1
|
228
|
|||
5
|
402
|