Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.
You can log in there with your existing account of this site.
The content remains free of charge.
The example in hand uses following CSV file and shall give an overview on the use of regular expressions.[4]
In the original state the manufacturer article number cannot be mapped on the corresponding one of the PARTsolutions catalog. Handicapping is the prefix "SK" before the manufacturer article number. The variance can simply be corrected by a regular expression, thus the automatic assignment can happen without problems then.
At first test the sample file with the settings under Section 1.1.6.1, “ Article Number Search standard procedure”. For this you just have to adjust the entry in the Product Source node on the new file. => No assignments can be made.
Now slightly modify the standard example:
In the toolbar's context menu call the docking window Available filters.
Drag the filter on the edge between Product Source and Find Article Number.
-> The settings dialog is displayed.
Perform the settings for the regular expression:
Define Regular Expression: Enter the desired regular expression.
(?:[^0-9]*)([0-9]+\.[0-9]+)
With this expression you can remove any number of characters and empty spaces (everything except numbers) from a numerical sequence splitted by a dot.
In order to test the action, under Input data, enter a number and click on . If the regular expression is correct, under Result, the desired result is displayed.
Case sensitivity: In the case of a case-sensitive prefix, activate the checkbox.
Field selection -> Field for modification: Determine the field to be modified. Here "Hersteller-Artikelnummer [manufacturer article number]".
Open the product assignment under Workspace -> Catalogs -> <Name of CSV catalog> -> Products.
[4] The used
sample file article_number_search_regexp.csv
can
be found under
"$CADENAS/training/partdatacenter/article_number_assignment".