Skip to main content
Question

How to separate text into attributes?

  • September 15, 2023
  • 6 replies
  • 641 views
pearly1
Contributor
Forum|alt.badge.img+4

 

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!

 

6 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

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.

pearly1
Contributor
Forum|alt.badge.img+4
  • pearly1Contributor
  • Author
  • Contributor
  • September 15, 2023
nielsgerrits wrote:

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.

nielsgerrits
VIP
Forum|alt.badge.img+54
pearly1 wrote:

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.

ebygomm
Influencer
Forum|alt.badge.img+32
  • ebygommInfluencer
  • Influencer
  • September 15, 2023
pearly1 wrote:

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

myrte.matthijs
1 person upvoted this
  • myrte.matthijs
    myrte.matthijs
pearly1
Contributor
Forum|alt.badge.img+4
  • pearly1Contributor
  • Author
  • Contributor
  • September 15, 2023

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

nielsgerrits
VIP
Forum|alt.badge.img+54
pearly1 wrote:

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

Cheers, fire away :)

Reply


Helpful Members This Week

Community Stats

31,139
Posts
118,062
Replies
38,758
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.