Newly added functions in the Function Builder tool are as follows:<\/p>\n
- \n
- Split<\/strong> – Splits the given string with a specified character and returns the value from the specified occurrence.<\/li>\n
- GetString <\/strong> – Returns the string value that matches with the regular expression pattern.<\/li>\n<\/ul>\n
The Function Builder dialog box is designed as text editable form. It is easy to construct a function to parse and assign metadata value for the SharePoint column. A simple Function Builder dialog is shown below:<\/p>\n
![\"formula\"](\"https:\/\/www.vyapinsoftware.com\/images\/blogs\/dockit\/formula.png\")
<\/a><\/p>\nThe Function Builder<\/em> allows you to create custom functions according to your metadata requirements. The Function Builder has nested functions support, intelli-sense popups to auto complete functions, file property names & metadata fields and built-in onscreen help to speed up the process of building functions to parse document metadata.<\/p>\n
An Example:<\/strong> Changing or modifying the file name using the Function Builder tool<\/p>\n
In the example below, let us say we would like to tag the parent folder name of the document in the file name in SharePoint i.e., OriginalFileName.doc to be renamed as OriginalFileName-ParentFolderName.doc.<\/p>\n
\n\nOriginal File Name<\/strong>
\nSampleDoc1.doc
\nSampleDoc2.pdf
\nSampleDoc3.doc<\/div>\nSource Path<\/strong>
\nF:OrgsContosoSampleDoc1.doc
\nF:OrgsNorthwindSampleDoc2.pdf
\nF:OrgAdventureWorksSampleDoc3.doc<\/div>\nNew File Name<\/strong>
\nSampleDoc1-Contoso.doc
\nSampleDoc2-Northwind.pdf
\nSampleDoc3-AdventureWorks.doc<\/div>\n<\/div>\n<\/div>\nSelect an existing template or create a new Column Mapping template<\/h3>\n
![\"template](\"https:\/\/www.vyapinsoftware.com\/images\/blogs\/dockit\/template-manager-81.png\")
<\/a><\/p>\nSelect Name column (property) and click Edit button or double click the Name column<\/h3>\n
![\"select](\"https:\/\/www.vyapinsoftware.com\/images\/blogs\/dockit\/select-template-manager.png\")
<\/a><\/p>\nSelect Use Function option in the Source drop down<\/h3>\n
![\"edit](\"https:\/\/www.vyapinsoftware.com\/images\/blogs\/dockit\/edit-column.png\")
<\/a><\/p>\nClick Function button in Edit Column<\/h3>\n
![\"edit](\"https:\/\/www.vyapinsoftware.com\/images\/blogs\/dockit\/edit-column-function.png\")
<\/a><\/p>\nConstruct the Formula as shown in the screenshot below and press OK<\/h3>\n
<\/a><\/p>\nAssign formula value to file Name property<\/h3>\n
- GetString <\/strong> – Returns the string value that matches with the regular expression pattern.<\/li>\n<\/ul>\n