AnsweredAssumed Answered

How do you create a custom import format with expressions?

Question asked by James Barnett on Jun 25, 2020

I'm creating a custom import using Regex, but I've run into a problem since every item is on a different line from the point file i'm trying to import.

I am trying to import this file:

PN:1
YC:746633.9425
XC:659081.7107
ZC:1287.4204
FE:CTL
"PD:5/8""REBAR/2""ALUM CAP"
SX:0.0089
SY:0.0135
SZ:0.0027
AC:OS
PN:2
YC:746670.0792
XC:659772.1563
ZC:1288.5750
FE:CTL
"PD:5/8""REBAR/2""ALUM CAP"
SX:0.0082
SY:0.0109
SZ:0.0027
AC:OS

 

I have written the expression to read it this way:

^\s*Pn:(?<PointId0>[\-+\s\w]+)yc:(?<Northing1>[0-9.e\-]+)xc:(?<Easting2>[0-9.e\-]+)zc:(?<Elevation3>[0-9.e\-]+)pd:(?<FieldCode4>[\-+\s\w]+)

pn:123yc:321321.02xc:908768.001zc:76.123pd:code

 

Does anyone know of a way to get the expression to drop to the next line and then repeat?

Outcomes