+2I 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?
+52One way to do this is using an AttributeCreator.
+31Another option is to use regular expressions to either delete everything before or after the space
+46Yet another way: get the individual words, as they are separated by a space character.
+52Yet 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!
+31Yet 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.
+46Somewhat surprisingly, @GetWord only searches for blank spaces (like space, tab, and new line), not interpunction.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
