Trimble Business Center

 View Only

How do you create a custom import format with expressions?

  • 1.  How do you create a custom import format with expressions?

    Posted 06-25-2020 10:05

    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?