Sage 100

I'm trying to remember how to import items/descriptions with the "" (inch) symbol without ending up with """". It seems like I was able to do this once but I can't remember how - and I've tried several different types of import files. Any help would be greatly appreciated!

Check the posts back a week or so. Dawn had this issue and posted a solution. Something to do with replacing the "" with a ^ in the import file, then using a subst formula in VI to change back to the

Thanks Jeff - found it - I'll give one or both of those solutions a try (replace double quote with single quote - or possibly change to ^ and change to quote if that won't work). Here is the formula that Todd posted in case anyone else is curious: SUB(IMP$[3],quo+quo,quo). Dawn's solution was replace the "" in the original file with ^ and the use this formaul in VI: SUB({CI_Item.ItemCode$}, ""^"", CHR(34)