I have a excel file with 3 columns (attributes) and fourth is a coordinates (lat/long) (polygon) which are separated by space and have different amount of numbers after the dot.
Input:
ID, Name, Number, Coordinates
01, First, 1001, 27.94324 34.34834 27.013 34.560 27.43479125 34.96844321
Desirable Output:
01, First, 1001, 27.94324 34.34834
01, First, 1001, 27.013 34.560
01, First, 1001, 27.43479125 34.96844321
AttributeSplitter cant do it
How to automate it?
Thanks for help in advance.