XY Coordinate

Hi @bayram​,

You can use an Aggregator transformer to group the records by fme_dataset, creating a list of the fme_text_string values. Then you can search that list with ListSearchers, using regular expressions to extract the x (1[0-9]+[.]*[0-9]*m) and y (3[0-9]+[.]*[0-9]*m) coordinates. Remove the 'm' from the coordinates using a StringReplacer, then create points using a VertexCreator.

I am attaching a workspace stub to illustrate.

Hello @daveatsafe​ 

Thank you very much for the answer, but I could not remove the values ​​from the list. I uploaded the excel data here. Can you help me if you have time?

1) xy values ​​in text string field

2) fme dataset field common field

I marked the xy values ​​with yellow color in Excel.

OK, you have some other values in there that aren't coordinates, but are caught by the ListSearchers. We can tighten up on the regular expressions to solve this, changing them to 1[0-9]{5}[.][0-9]{3}m and 3[0-9]{5}[.][0-9]{3}m. This will only extract the true coordinate values.

I am attaching an updated workspace that incorporates your dataset.

Thank you very much for your answer, it is very successful.