+4I 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?
+64One way to do this is using an AttributeCreator.
+46Another option is to use regular expressions to either delete everything before or after the space
+60Yet another way: get the individual words, as they are separated by a space character.
+64Yet 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!
+46Yet 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.
+60Somewhat surprisingly, @GetWord only searches for blank spaces (like space, tab, and new line), not interpunction.
