Regular expressions

Tekla PowerFab
Modified: 14 Sep 2022
2024i
Tekla PowerFab Tekla PowerFab GO

Regular expressions

You can use regular expressions to specify a pattern for importing multiple fields or for ignoring records that you do not want to import.

For the syntax of regular expressions, see Regular Expressions.

The Expression option allows to extract multiple fields from a single value in the import by specifying a regular expression with the field names as placeholders in the expression.

If you have a column with the Project # category and a sub-category separated by slashes, for example, 22-012/CAT1/SUBCAT2, you can set the expression to `Project`/`Category`/`Sub-Category`. As a result, the individual values (Project=22-012, Category=CAT1, Sub-Category=SUBCAT2) are extracted and used for those fields.

You can use Ignore Expression to indicate that a row must be ignored.

If you have a column with the Project # category, and the data set includes job types that you do not want in Tekla PowerFab, for example, ones beginning with the letter M, you set the Ignore Expression to M.*. As a result, any time-tracking records projects beginning with an "M" are not be imported.

Was this helpful?
Previous
Next