home › Forums › idx general support › How can I do RegEx search and replace in the Editing window? › Reply To: How can I do RegEx search and replace in the Editing window?
We figured it out. The regular expression for this particular task is (don’t forget to activate rx and select the appropriate column):
Search:(^[0-9-,]+)(.*) and Replace: \1\2;\2\1
If the function is used frequently, it is useful to create a new function in the “Index-Action” window. Or save the regular expression in the notes window if you want to apply the action in the “Edit” window.
These two links to regex are very good, especially the test platform for creative testing.
Table: http://www.cbs.dtu.dk/courses/27610/regular-expressions-cheat-sheet-v2.pdf
Test-page: https://regex101.com