A Geek’s View on Part Numbers

I feel a bit geeky today. I posted about part numbers, document number and numbering few times in the past. These posts sparkled an intensive discussion about all possible and impossible data schemas, intelligent numbers and standards for part numbering. I want to give you a bit different approach to think about Part Numbers – Regular Expressions. First of all, what is that? This is how Wikipedia defines regular expressions.

In computing, a regular expression, also referred to as regex or regexp, provides a concise and flexible means for matching strings of text, such as particular characters, words, or patterns of characters. A regular expression is written in a formal language that can be interpreted by a regular expression processor, a program that either serves as a parser generator or examines text and identifies parts that match the provided specification.

Navigate to the link to the following article – How to use regular expression to search better and save time? Take a moment of time and read it. You will find a lot of interesting tips how you can create various queries that fits your numbering models for documents and parts. The article provides good examples on how to use regular expressions and link to additional resources.

What is the conclusion? I hope you enjoyed my "geeky tips". Speaking seriously and thinking about practical aspects, regular expressions are good only when your PLM software supports them. Did you get any experience with this in the past? Can you share any examples of regular expression usage in your PDM/PLM software?

Best, Oleg

6 Responses to A Geek’s View on Part Numbers

  1. maheshberi says:

    I remember one instance I used regular expression in a real PLM project several years ago.

    Customer had a specific rules to create part descriptions based on certain characteristics of the part.
    example – “attribute [Material] and related [Product family]”.
    These expressions were sometimes cryptic and in order to save maintainence/programming effort .. I used regular expression to parse the expression and replace it with actual values.
    This way whenever the information in the system changed the descriptions were updated.


  2. Mahesh, thanks for this example and thanks for commenting. What system you sue to implement that? best, Oleg

  3. Cecil says:

    If you implement a data warehouse for your PLM, then you can use Oracle SQL which supports regular expressions since 10g

  4. Cecil, thanks for the comments! Can you bring examples of Oracle usage of regex with data warehouse solutions? Best, Oleg

  5. Mahesh Beri says:

    Solution was for a high tech customer for its Part data creation. PLM used was Matrix 10.5.x and programming language was Java.


  6. Thanks! Do you know, if Matrix/DS came with the inclusion of similar functionality in later releases?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 288 other followers

%d bloggers like this: