Extracting some elements from the string
-
Hello,
Maybe I will show what I mean.
I have this:
"bbox":[32614000.00000020,5743999.99999951,32616000.00000020,5745999.99999956],"coordinates":[[[32614000,5745999.99999956],[32616000,5745999.99999952],[32616000,5743999.99999951],[32614000,5743999.99999956],[32614000,5745999.99999956]]]},"properties": {"id": "571553","label": "326145744"}},{"type": "Feature","geometry": "bbox":[32614000.00000020,5747999.99999951,32616000.00000020,5749999.99999956],"coordinates":[[[32614000,5749999.99999956],[32616000,5749999.99999951],[32616000,5747999.99999951],[32614000,5747999.99999956],[32614000,5749999.99999956]]]},"properties": {"id": "571554","label": "326145748"}},{"type": "Feature","geometry": "bbox":[32614000.00000020,5751999.99999951,32616000.00000020,5753999.99999956],"coordinates":[[[32614000,5753999.99999956],[32616000,5753999.9999995],[32616000,5751999.99999951],[32614000,5751999.99999956],[32614000,5753999.99999956]]]},"properties": {"id": "571555","label": "326145752"}},{"type": "Feature","geometry":And I need this:
571553,571554,571555How to extract that ?
Thank you,
-
I think this regex will do the trick:
Search: (?-s).*?"id": "(\d+).*?|.* Replace: ?1$1,Put the caret at the very beginning of the document, select just the
Regular Expressions modeand click onReplace All. That’s all.Take care and have fun!
-
Works beautifully. Thank you :)
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login