You can pull out (extract) a specific set of data from within an existing source property column and place it within another property column for an entire folder or individual items.
Only results that can be pulled directly from the item's metadata value will be returned when the extraction is run. This type of extraction can be useful for pulling content from a single item, or pulling a set of content from all items at one time.
Before an extraction action is started, make sure you have a good, clear idea of what content is to be extracted.
This option is only available when Advanced Mode is enabled.
To Extract Content from a Property:
1.In Explorer View, select the folder that contains the content you want to extract.
2. To display the Extract Content from Property dialog, use on of the following options:
§To extract content from the entire folder, right, click and choose Metadata Modifications > Extract Content from Property.
§To extract content from one or more items, switch to Items View, select the item(s) and choose Metadata Modifications > Extract Content from Property.
3.Enter the search parameter in the Find field.
4.This can be an XPath query, plain text, a number value, part of a user name, etc
Select a Search value from the drop-down.
5.Select a Search Logic option, based on the type of data that you want to extract. Options are:
§XPath Query - If the property contains XML, an XPath query can be used to extract information.
§Regular Expression - Uses a "Regular Expression" search expression to find text.
When this options is selected the Multiline option becomes available and, if checked, regular expressions will search past new line characters.
§Text Search - Runs a text search through the selected property field, looking for a value that matches the text in the Find option.
When this option is selected the Match Case option becomes available which, if checked will make the search case sensitive.
6.If you want to run the extraction on any sub-folders under the currently selecte folder, check the Recursive box
7.Set the desired Extract option. Use the information in the following table for guidance.
If you want to ...
count the number of matches Metalogix Content Matrix can find in the source content that matches to the Find value and enter that number in the selected output column
For example, if a property column contains values that are written in HTML, and you want to find out how many "<P>" tags are in the property value, you can enter an XPath query to select all "<P>" tags, and run the extraction. The number of "<P>" tags in that property column value will be returned in the selected column. So if there are five paragraphs in the property value, the extraction will enter "5" in the selected output property column.
select Counts only.
search for and extract the first match value found for each item
First Match Only.
search through the selected content and extract all values that match the Find value and appended them as a string of text into the output property column
All matching results.
8.If you selected All matching results, enter a Separater value so that each returned result will be separated within the same cell in the Workspace:
§; - Adds a semi-colon between results.
§: - Adds a colon between results.
§\t - Adds a "Tab" between results.
§\n - Places the new results on a new line.
§\r\n - Adds a carriage return and new line between results.
9.If you elected XPath Query as the Search Logic, set the desired Format option:
§Text - When selected, this option will run the search through the text level of the code (within the property value), and the output will only contain the text, and not any of the actual code. For example, in the xml node: <xml><inner>text</inner></xml> the returned extracted value would be "text."
§Inner XML - When selected, this option will search and extract any text values as well as any of the inner XML coding. For example, in the xml node: <xml><inner>text</inner></xml> the returned extracted value would be "<inner>text</inner>."
§Outer XML - When selected, this option will return all of the xml code that matches the XPath value. For example, in the xml node: <xml><inner>text</inner></xml> the returned extracted value would be"<xml><inner>text</inner></xml>."
10.In the Extract to column drop down menu, select a new or existing property column that the data will be extracted into.
If a target column for the extraction does not already exist, click [New] and add the column.
11.Click [Run] to run the extraction immediately or save a copy of the settings to a job file, which displays in the section. You can then:
§ run a migration directly from the Jobs List section
§schedule the job to run at a specified time, either as a Windows Scheduled Task or straight from PowerShell.