VI import item descriptions with inch symbol

SOLVED

I have a need to import new inventory parts that have the inch symbol as part of the description.  The file was given to me as an Excel file so when I save it as a csv it puts double quotes in the description.   

Example:  Mating Deck 12" X 1 1/2""

I remember years ago that someone shared with me a way to import using VI and being able to correct this.  I believe we had to replace the quote symbols in the Excel file with a different symbol, save as csv, then in the VI job it somehow replaced the different symbol and changed it back to the quotes.  I can't seem to find my instructions.  It was a very long time ago.  The file has almost 30,000 parts in it so I really don't want to edit it in Notepad.  

Does anyone have any instructions on how to do this?  I checked the Knowledgebase but couldn't find anything.

Thanks.

Sue

Parents
  • 0

    This from Sage Support in 2008!

    You'll need to use SUB Functions. Modify your sourcefile by replacing all " with * and replace all , with ^. You can then use the attached sample. The attached import uses SUB functions which will change the * back to " and change the ^ back to ,

    If you are on a current version your best option is actually Excel.

Reply
  • 0

    This from Sage Support in 2008!

    You'll need to use SUB Functions. Modify your sourcefile by replacing all " with * and replace all , with ^. You can then use the attached sample. The attached import uses SUB functions which will change the * back to " and change the ^ back to ,

    If you are on a current version your best option is actually Excel.

Children
No Data