I recently got the results of a survey I had created from the LimeSurvey tool. The results were outputted in Microsoft Word .docx documents and for some reason, some strings got merged with the survey questions. For example : (SQ001)[text for a question].
I am trying to match all strings that start with (SQ001), are followed by a square bracket, then have some text, and are followed up by another square bracket. Basically, I want to extract the inner text of the square brackets while removing the rest of the characters, making:
(SQ001)[some text] –> some text
Some of the regex I tried was:
- Replace (w{2}d{3})[(.*?)] with 1
- Replace ((SQ[0-9]{3}))[(.*?)] with 2
But none of these worked.
(And yes, I have enabled the option ‘Use wildcards’)
