A Migration Job using a tab-delimited text file (exported from Excel) always wraps text values like a part description in double quotes when the file is loaded — how do you get the imported value without the surrounding quotes?

All FAQ questions / Data migration

Answer

Set the 'String Delimiter' option on the migration job's file-loading configuration to the double-quote character — this tells the loader to treat leading/trailing double quotes as a string delimiter (and strip them) rather than importing them as literal characters that end up embedded in the field's value.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Data migration questions