Skip to main content
  • EN

 

parsing text stringHi,

New to FME here. I have been tasked with creating a workbench to convert DWG to GIS (storm water asbuilts). Below is the autocad text string field which contains three rows. first structure name, Top elevation and on invert elevation.

I would like to know a way to separate this into three fields. I have created the fields with Attribute manager but have no idea how to parse this out.

 

I was thinking it could be based on line row number? Since Multiple types of structures and line is always structure name, line 2 is always top, and line three is always Invert elevation.

 

Thanks!

 

You can split this using an AttributeSplitter. Open the text box for the seperator character and hit Enter. This will result in a list with 3 elements.

You can split this using an AttributeSplitter. Open the text box for the seperator character and hit Enter. This will result in a list with 3 elements.

imageIs this what you mean? I have tried this and the splitter seems to not separate the field.

imageIs this what you mean? I have tried this and the splitter seems to not separate the field.

Yes this is how it works. The listelements will be visible in the Feature Information window, on the right side of the Data Inspector screen.

imageIs this what you mean? I have tried this and the splitter seems to not separate the field.

After splitting you will need to do something like this to get the split values into visible attributes

image

Thank you both! this really helped. I'm sure I will have many more questions through out this process.

Thank you both! this really helped. I'm sure I will have many more questions through out this process.

Cheers, fire away :)

Reply


Community Stats

30,109
Posts
114,302
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.