A dataset of 900 records contains a string attribute. This string varies in length and contains always a X- and Y-coordinate.
Example:
":5.781699137962022,"rijksdriehoekX":181934.095,"rijksdriehoekY":474580.092,"rijksdriehoekZ":0
I just want to get the part in bold and created a Regex to select this part. My idea is to replace the complete string and just keep the string part with the coordinates (bold part).
My Regex: rijksdriehoekX":t0-9]{6}.60-9]{3},"rijksdriehoekY":t0-9]{6}.60-9]{3}
Any ideas how to solve this issue?