Consider the following:Instead of pulling the data directly, pull it via a BAQ. In the BAQ, use a calculated value to substitute special characters with a custom string. For example, Replace double and single quotes in part numbers which contain feet (‘) and inches (“) as “__DQuote__” and “SQuote__” respectfully.E.g. Calculated value for a field name PartNum would be: replace(replace(PartNum, ‘’’’, ‘__SQuote__’), ‘”’, ‘__DQuote__’)Note that to escape a single quote through, you must enter it twice (i.e. ‘’), then wrap the escaped single quote inside single quotes (i.e. ‘’’’).The 50 character PartNum limit no longer applies because the string is outside of the DB storage string length.On the receiving end, undo the replacement as needed using whatever tools logic is needed. Note that this also brings the string back into its <=50 character limit (Epicor.Part.PartNum column limit is 50 characters).This method allows any special character characters (subject to vary depending on p
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.