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

    I'd use the Excel text import wizard, which should remove the duplicate quotes.  Then do a find and replace (in Excel) for the quote marks to be something else (like "^") and add a formula in the VI job to substitute back the quote character.  (VI does odd things with quotes at the beginning / end of each field, so it's best to just avoid them entirely in your CSV file).

    This example replaces "^" with CRLF, but should be a good hint at the syntax.

Reply
  • 0

    I'd use the Excel text import wizard, which should remove the duplicate quotes.  Then do a find and replace (in Excel) for the quote marks to be something else (like "^") and add a formula in the VI job to substitute back the quote character.  (VI does odd things with quotes at the beginning / end of each field, so it's best to just avoid them entirely in your CSV file).

    This example replaces "^" with CRLF, but should be a good hint at the syntax.

Children