如何让TXT中的文本数据在EXCEL中以特定分隔符为标记分列

txt文件中示例文本

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
BSM ( type: esriFieldTypeInteger, alias: 标识码 )
YSDM ( type: esriFieldTypeString, alias: 要素代码, length: 10 )
JZDH ( type: esriFieldTypeString, alias: 界址点号, length: 10 )
JBLX ( type: esriFieldTypeString, alias: 界标类型, length: 2 )
JZDLX ( type: esriFieldTypeString, alias: 界址点类型, length: 2 )

通过 SublineText 格式化后

OBJECTID,OID,OBJECTID
SHAPE,Geometry,Shape
BSM,Integer,标识码
YSDM,String,要素代码,10
JZDH,String,界址点号,10
JBLX,String,界标类型,2
JZDLX,String,界址点类型,2

WPS - 数据 - 导入数据