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.

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.

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}n.]t0-9]{3}m and 350-9]{5}9.]30-9]{3}m. This will only extract the true coordinate values.

I am attaching an updated workspace that incorporates your dataset.

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.

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