Options

When you click Reset (below), this box shows the regular expression created by the fields you added in the previous Fields dialog.

You can manually edit the expression by:

• clicking in the box and typing new syntax
• clicking Back to return to the Fields dialog where you can add and remove fields
• cutting-and-pasting a pre-defined expression (see an example expression below) and editing it as needed

Click this to update the regular expression box with the fields you added in the previous Fields dialog.

Regular Expression Example

If your data looked like this:

Point "783721",1.020504836526262,2.350757695493461e-001,161.924222568444750,"104",,
Point "783831",1.021434930822021,2.354825559721977e-001,141.666434510332460,"104",,
Point "SILO",1.021145841465939,2.356510353092979e-001,139.771999999999990,,,

You would select these fields in the Fields dialog:

Point ID, Northing, Easting, Elevation, and Feature Code

After clicking Reset in the Regular expression dialog, the expression would be started:

^(?<PointId0>)(?<Northing1>)(?<Easting2>)(?<Elevation3>)(?<FieldCode4>)

You would need to finish the expression by adding these to match the data:

^\s*Point\s"(?<PointId0>[\-+\s\w]+)",(?<Northing1>[0-9.e]+),(?<Easting2>[0-9.e\-]+),
(?<Elevation3>[0-9.e\-]+),"(?<FieldCode4>[^"]*)

Here are the reasons to add each operator and character to the syntax:

\s*Point\s"

\s* matches zero or more white spaces at the beginning of the line; Point matches the word identifying the next value as a point ID; \s matches a single white space; the open and closed " match the quote marks around the point ID group

[\-+\s\w]+

the brackets [ ] specify to match any character identified within them; \-+ matches either the positive or negative sign in front of the point ID and \w matches any alphanumeric character for the point ID; + outside the brackets repeats the matching to account for any combination of the allowed characters

,

, specifies that a new field follows

[0-9.e\-]+

0-9 matches any numerals for the northing, easting, and elevation in the 0-9 range; .e\- matches any decimal, e or minus sign encountered in the value

[^"]*

^" matches any string for the feature code until the next " is encountered; * matches any characters after that

Value you are specifying

Keyword to use

Easting

Elevation

EllipsoidalHeight

FieldCode

Latitude

Longitude

Northing

PointId

XECEF

YECEF

ZECEF