Question & Answer
Question
When building a process list for the Item loader (DdmLoader.exe), the import file is a comma separated values (csv) file. Since commas are used to separate the values, how do you add a metadata value that contains commas? For example: Smith, Joe?
Answer
If you use Microsoft® Excel for editting, your csv file which is created as an export from the Item Loader. You will be able to add values containing commas. Note that you do not need to include columns that do not contain values.
When you save this file, you will be prompted with the following message:
Select Yes.
When you view the contents of the saved file in a text editor like Notepad, you see the following:
This points out the alternate way of getting the values with commas into the csv file. Use a plain text editor to put double quotes around the values containing a comma. The sample file shown above contains three items to load where the Author Attribute contains a mixture of values:
- Value that does not contain a comma - no double quotes needed
- Multiple comma separated values - Note the double quotes around the whole string
- Another value containing a comma with double quotes to keep the value together
Once you load this file into the Item loader (Items -> Import CSV file...) , you can see that the values with commas are preserved.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21222839