Folder

The folder being accessed.

Select

Optional. A string with a regular expression or a data series including strings with several regular expressions that determine the object names to be found.

^

Finds the beginning of the string.

$

Finds the end of the string.

*

Never finds the preceding character or finds it several times. For example, "zo*" finds "z" or "zoo".

+

Finds the preceding character once or several times. For example, "zo+" finds "zo", but not "z".

?

Finds the preceding character zero times or once. For example, "b?ig?" finds "ig" in "signal".

.

Finds every single character.

x|y

Finds either x or y. For example, "z|wood" finds "z" or "wood". "(z|w)oo" finds "zoo" or "wood".

{n}

n is a non-negative integer. Finds exactly n times. For example, "o{2}" does not find the "o" in "Bob", but it does find the first two o’s in "foooood".

{n,}

n is a non-negative integer. Finds at least n times. For example, "o{2,}" does not find the "o" in "Bob", but finds all o’s in "foooood." "o{1,}" is equivalent to "o+". "o{0,}" is equivalent to "o*".

{n,m}

m and n are non-negative integers. Finds at least n and at most m times. For example, "o{1,3}" finds the first three o’s in "fooooood." "o{0,1}" is equivalent to "o?".

[xyz]

A group of characters. Finds every one of the characters included. For example, "[abc]" finds the "a" in "signal".

[^xyz]

A group of excluded characters. Finds every character not included. For example, "[^abc]" finds the "s" in "signal".

[a-z]

A range of characters. Finds every character in the range. For example, "[a-z]" finds every alphabetical character from "a" to "z".

[^m-z]

A range of excluded characters. Finds every character not in this range. For example, "[m-z]" finds every character that does not lie between "m" and "z".

\b

Finds a word limit, i.e. the position between a word and a space character. For example, "al\b" finds the "al" in "signal", but not the "al" in "signals".

\B

Finds a non-word limit. "ea*r\B" finds "ear" in "never early".

\d

Finds a number. Equivalent to [0-9].

\D

Finds a non-numeric character. Equivalent to [^0-9].

\s

Finds a space character. Equivalent to "[ ]".

\S

Finds everything but space characters. Equivalent to "[^ ]".

\w

Finds every word character including underline. Equivalent to "[A-Za-z0-9_]".

\W

Finds every character that does not belong to a word. Equivalent to "[^A-Za-z0-9_]".

2D Diagram

.2D

3D Diagram

.3D

Analysis Object Derivation/Integral

.SAN

ANOVA Analysis Object

.ANV

Goodness-of-Fit Test Analysis Object

.ADJ

2D-Approximation Analysis Object

.AP2

Approximation Analysis Object

.APX

Outlier Correction Analysis Object

.RFR

Outlier Test Analysis Object

.FRT

Acceleration Hyperbola Family Analysis Object

.AHP

Cepstrum Analysis Object

.CEP

CFC Filter Analysis Object

.CFC

Speed Synchronous Order Tracking Analysis Object

.SOA

Speed Synchronous Order Filter Analysis Object

.SOF

Envelope Analysis Object

.ENV

Event Isolation Analysis Object

.EVI

Excel Workbook Analysis Object

.XLD

Convolution Analysis Object

.CNV

FFT Analysis Object

.FFT

FIR Filter Analysis Object (Equiripple Method)

.FI3

FIR Filter Analysis Object (Window Method)

.FI2

Fourier Spectrum Analysis Object

.FSP

Uneven Data Fourier Spectral Analysis Object

.UFS

Human Body Vibration Analysis Object

.HBV

Split Order Analysis Object

.SOR

Hand-Transmitted Vibration Analysis Object

.HTV

Harmonic Estimation Analysis Object

.HSP

Histogram Analysis Object

.HST

High-performance Frequency Estimation Analysis Object

.HFE

IFFT Analysis Object

.IFT

IIR Filter Analysis Object

.FI1

Count Analysis Object

.CNT

Count Matrix Analysis Object

.CMX

Correlation Analysis Object

.CCF

Circle Approximation Analysis Object

.CAP

Cross Spectrum Analysis Object

.CSP

Curve Transformation Analysis Object

.CVT

Loudness Analysis Object

.LDS

Linear Interpolation Analysis Object

.LPL

Instantaneous Quantities Analysis Object

.INQ

Non-linear Curve Fit Analysis Object

.NLF

Surface Interpolation Analysis Object

.SP2

Octave Analysis Object

.OCT

Order Tracking Analysis Object

.ODA

Parametric Spline Interpolation Analysis Object

.PSP

Rainflow Count Analysis Object

.RFC

Regression Analysis Object

.RGS

Rosette Transformation Analysis Object

.ROT

Sound Power Analysis Object

.SPW

Sound Level Analysis Object

.SVL

Sharpness Analysis Object

.SHS

Signal Analysis Object

.SIG

Signal Sampling Analysis Object

.SIS

Signal Filter Analysis Object

.IIR

Signal Smoothing Analysis Object

.SMT

Signal Correction Analysis Object

.CLN

Signal Scaling Analysis Object

.SCL

Spline Interpolation Analysis Object

.SPL

Statistical Quantity Analysis Object

.STQ

Shock Response Spectrum Analysis Object

.SRS

Variance Test Analysis Object

.VRT

Compound Count Analysis Object

.CCN

Distribution Analysis Object

.DIS

Confidence Interval Analysis Object

.CIV

Time-Frequency Spectrum Analysis Object

.TFS

Worksheet

.WKS

Control panel

.CPN

Binary Data Link

.BIN

Data Query

.DQY

Data Set

.DAT

ASAM ODS Data Link

.ODS

Data Link, Astro-Med Dash 18 Data

.DCR

Data Link, B+S ME 3 Data

.BUS

Data Link, BMCSAD Data

.BMC

Data Link, File Data

.FIP

Data Link, Gould Oscilloscope Data

.GSC

Data Link, Imtec INSIGHT Data

.IST

Data Link, IMTEC PC-Scope Data

.PCS

Data Link, IOtech Data

.IOT

Data Link, LeCroy Waveform Data

.LCS

Data Link, The MathWorks MATLAB Data

.MAT

Data Link, Meyer and Heinen EDAS Data

.EDS

Data Link, NASA CDF Data

.CDF

Data Link, NI DASYLab Data

.DST

Data Link, NI DIAdem Data

.DAG

Data Link, Nicolet TEAM Data

.TEM

Data Link, Nicolet WFT Data

.WFT

Data Link, ODBC Data

.ODC

Data Link, OROS Wave Data

.OWV

Data Link, SEFRAM Recorder Data

.SF1

Data Link, SPSS Data

.SPS

Data Link, Stemmer TurboLab Data

.TBL

Data Link, SYSTAT Data

.STT

Data Link, TEAC TAFFmat Data

.TFM

Data Link, Tektronix DPO Data

.DPO

Data Link, Tektronix TDS Data

.TDS

Data Link, Wave Data

.WVE

Data Link, Yokogawa ORM/ORP Data

.ORP

Data Link, Ziegler Signalys Data

.SGL

Document

.DOC

Excel File Data Link

.EXC

Excel Data Link

.XDL

Formula

.FML

Media

.MED

OLE Data Link

.OLE

Folder

.FLD

Column table / Row table

.TAB

Text

.TXT

Text Data Link (obsolete)

.ASC

Text Data Link

.TEX

Cell Table

.TTB

\Measurement1\.Objects("^sig.*\\.dat$").Names

Finds all data set objects in the folder "\Measurement1" with names beginning with "sig".

The regular expression is structured as follows:

.\.Objects({".*\\.dat", ".*\\.fml"}).Names

Finds all formulas and data sets in the folder containing the actual formula.

\.Objects.Names

Lists all objects in the root folder of the project database.

Dim List, Result, Path, i

List = Measurement1\.Objects.Names

Path = Measurement1\.FullName : "\\"

For Each Row i in List Do

    Result = Result : Mean($Path : List$)

End

Calculates the mean values for all objects in the subfolder "Measurement1", assuming that this folder contains only data objects.