Sage 100

Try double quotes: ""

Many import tools use this method

Another method that may work is, in the source file, do a find on " and then replace with $ or *.  In the VI import use the SUB (substitute) command to substitute the $ with ". 

Another method that may work is, in the source file, do a find on " and then replace with $ or *.  In the VI import use the SUB (substitute) command to substitute the $ with ". 

I tried double quotes and I tried a quote at the beginning and end of the description.  @Doug Higgs, do you have a screen shot of a VI job where you did this?  @Susan Pawlowic, I saved the below, however did not download the attachment.  I tried to find your original post.  Can you send me the attachment and a screen shot of the data tab will all the fields and then an screen shot showing your calculation.  I know yours is item code and I'm doing item description. 

Another method that may work is, in the source file, do a find on " and then replace with $ or *.  In the VI import use the SUB (substitute) command to substitute the $ with ". 

@Michele Herzog  Here's a simple example.  See the VI job attached to this post and the explanation below.

Excel file with asterisks replacing the quote marks

Exported the Excel file to Tab Delimited format

I tried double quotes and I tried a quote at the beginning and end of the description.  @Doug Higgs, do you have a screen shot of a VI job where you did this?  @Susan Pawlowic, I saved the below, however did not download the attachment.  I tried to find your original post.  Can you send me the attachment and a screen shot of the data tab will all the fields and then an screen shot showing your calculation.  I know yours is item code and I'm doing item description. 

Another method that may work is, in the source file, do a find on " and then replace with $ or *.  In the VI import use the SUB (substitute) command to substitute the $ with ".