Skip to main content

I have a Geometry column that includes an easting and northing that is separated by a space in the middle as follows:

 

I want to split this data up so that eastings go into one column and northings go into another. I have tried using an AttributeSplitter with a space as the delimiter and then a ListExploder to view the results but unfortunately this doubles the number of records in my data instead of creating two unique columns. 

How can I create two separate columns from my data?

One way to do this is using an AttributeCreator.

 


Another option is to use regular expressions to either delete everything before or after the space

 


Yet another way: get the individual words, as they are separated by a space character.

 


Yet another way is to use an AttributeCreator in yet another way😉

Get the individual words, as they are separated by a space character.

 

Learned something new today, thanks!


Yet another way: get the individual words, as they are separated by a space character.

 

I wouldn’t have expected @GetWord to include the . character but i see that it does. 


Somewhat surprisingly, @GetWord only searches for blank spaces (like space, tab, and new line), not interpunction.


Reply