Parse property values for mapping - Intergraph Smart Interop Publisher - Help

Intergraph Smart Interop Publisher Help

Language
English
Product
Intergraph Smart Interop Publisher
Search by Category
Help
Smart Interop Publisher Version
16.2

All mapping spreadsheets provide a Property Value Parsing Expression column that enables you to parse a specified source property value and remove any unwanted or extraneous strings, and also extract any portion of a property value string specified in a regular expression format. This feature provides a better one-to-one mapping for property values from third-party data with Smart 3D and SmartPlant Foundation (EFSchema) target properties.

For example, the designPARTNAMET-578687 source property name can be parsed to remove 'designPARTNAME-' so that Smart Interop Publisher uses T-578786 as the property value for the mapping.

  1. From the PropertyMap sheet in the spreadsheet you are editing, enter a string parsing expression in the Property Value Parsing Expression column for each source property value to change. Here are some examples:

    Example Property Value

    Property Value Parsing Expression

    Extracted Property Value

    PartNAME,T-578687-UTB-100856

    (value=.*),

    PartNAME

    PartNAME,T-578687-UTB-100856

    ,(value=.*)

    T-578687-UTB-100856

    Assembly,T-578687-UTB,Name

    ,(value=.*),

    T-578687-UTB

    PartNAME,T-578687-UTB-100856

    -(value=.*)-.*-

    578687

    Smart Interop Publisher supports all standard Regular Parsing Expressions. The Property Value Parsing Expression format is similar to the Regular Expression, except that the portion of the property to be extracted comes after "value=" and is enclosed in parentheses ().

  2. Finish your mapping and then translate the source file(s). Review the resulting model property display to check your changes.