The first two are easy and can be extracted without issues.
Question Number [A-Z]{1}\d(?<QuestionNumber>\d{2})
Start cursor at place where letter can be found for 1 character and a digit for 1 character finally get the next two digit characters, which in this case are the question numbers.
Since the input string has two different type of questions we have to take this one at a time. Here we first put the cursor to the start of the Question. Question line always contains the question type in the end of the sentence. It is important that you know all the question types before hand and each question type will have to be seperately extracted. Here I show only the numeric and SingleCoded types. It is impossible to use Regex if the text has an unknown pattern.
Not Back will not be immidiate word as you mentioned so this one is tricky. See question 14 string it has an extra string Input - and new line. I am not sure how to get this. May be someone who is really good at regex can help you here.
Options (Grouped syntax) `` 1\s(?<Option1>\w.*(\n|(?!\?)))2\s(?<Option2>\w.*)\n|3\s(?<Option3>\w.*)\n|4\s(?<Option4>\w.*)
We place the cursor to start at each options bullet. In this case it is numbered and then check if the number has a space. Option 1 is the tricky one because in your input string you have a question which ends with a similar pattern “1 month?” so we have to use a negation (\n|(?!?)) rest of the options is quite straight forward: check for word and continue till the end of the line.
@jeevith …Thanks for your suggestions.
One thing here, for the 2nd result, Question Type can be of any type and formatting of that line can vary as well (But the line will always start with ‘Q0’) . Here I have given reference of 2 types only (Single coded, Numeric). Can we have more dynamic pattern for this one as well?
@DewanjeeS - Since @jeevith already provided a very good regex…I just sharing my views here…
Since Single Coded(2 words), Numeric is (1 word) I think capturing is little difficult(I may be wrong here) , so I have added or condition… feel free to add any options which comes …
@prasath17 … Thanks for your suggestions… Let me try with different combinations for the 2nd one and I will let you know if it’s working or not.
For the capturing ‘Question’ part, initially I posted a separate thread which you mentioned here.
But later it has been observed that even though all the time Question starts ‘Not back’, end identifier keyword ‘Normal’/‘End’ may not be there always (You can see Q015 for reference, even though it started with ‘Not back’ there is no such end keyword for this one).
Hence, posted it separately here along with other questions as well…
Hi @DewanjeeS …Please check this below regex…It is capturing the values for Q015 too…Here i have used an idea that, Any text between Not Back and (Normal or Q0)…
I agree with @prasath17, (Question 2) It is impossible to looking for characters/words without knowing what characters are possible in your input string using Regex.
Why is it impossible?
Although the question type is usually at same line at Q0 the word itself (type) can be a single word, two words or multiple words. The question type can be of any number of words. Without knowing this regex can never know what to look for. In addition, there are no unique separator characters which could help anchor the search either.
QuestionType possible text:
Numeric
Single Code
Foo Bar Bar
Foo Foo Bar Bar
So you will either need to have a list of possible question types to search or manually make a list of possible question types. Then tweak the regex expressions in this thread to match those terms.
@prasath17 and @jeevith … Thanks a ton to both of you for looking into this one and providing your valuable inputs.
I am able to fetch below as of now -
Question Number
Question Type
For 3) Question - I will check with concerning Team if we can get a fix end key identifier, for which I can apply the fix @prasath17 has provided in one of the earlier posts.
Only thing remaining is - 4) Options (Always starts from the next line of keyword ‘Normal’) - Is there a way we can fetch that as well?
This should get you all the options. If there are only two options then this will return only two matches if there are 4 options then it gets matches for all of them.
You could also extend this to more options if some questions have more than 4 answers.
.....\n|5\s(?<Option5>\w.*) etc. Here \n says look to nextline and search for number 5 and after a space character capture all words until the end of the line and name this group Option5.
Is there a way we can get the Variable type of each Questions?
Pattern for the same will be as below -
Question Number - Variable ID: *******Question Type
Question Number and Question Type, I am able to fetch with the pattern @prasath17 shared above i.e. ([qQ]\d{1,}).*(Single coded|Numeric|Multi coded|Matrix|Shared list|Text)).
Variables Id’s will be below from above Input Text -
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu