Extract Text after each iteration

Question

Hi Team,&nbsp;I have the data in the below format from DB.&nbsp; I need to extract the text after every "SectionHdr",&nbsp; "QuestionHdr", "QuestionTxt" and "SectionRe".&nbsp; Please help me as i'm unsure on how to iterate multiple times within the same text.&nbsp; I have also added a sample of Output im trying to achieve.&nbsp;Column1&nbsp; (Input)&nbsp;[{&nbsp; &nbsp; &nbsp; &nbsp; "Questionnaire": [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAIs": "vvv; ooo",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAf": "rrrr; ppp; aaa ",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionDr": "10",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionHdr": "header1",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionID": "af-afddfadsf",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionSts": "dasdff",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionTxt": "text1"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAIs": "vvv; ooo",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAf": "rrrr; ppp; aaa ",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionDr": "10",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionHdr": "header2",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionID": "af-afddfadsf",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionSts": "dasdff",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionTxt": "text2"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAIs": "vvv; ooo",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAf": "rrrr; ppp; aaa ",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionDr": "10",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionHdr": "header3",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionID": "af-afddfadsf",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionSts": "dasdff",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionTxt": "text3"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAIs": "vvv; ooo",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAf": "rrrr; ppp; aaa ",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionDr": "10",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionHdr": "header4",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionID": "af-afddfadsf",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionSts": "dasdff",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionTxt": "text4"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; "SectionCs": "",&nbsp; &nbsp; &nbsp; &nbsp; "SectionDr": "20",&nbsp; &nbsp; &nbsp; &nbsp; "SectionHdr": "Sec1",&nbsp; &nbsp; &nbsp; &nbsp; "SectionID": "wefwe-1001",&nbsp; &nbsp; &nbsp; &nbsp; "SectionRe": "N"&nbsp; &nbsp; },&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; "Questionnaire": [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAIs": "vvv; ooo",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAf": "rrrr; ppp; aaa ",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionDr": "10",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionHdr": "header1",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionID": "af-afddfadsf",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionSts": "dasdff",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionTxt": "text5"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAIs": "vvv; ooo",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAf": "rrrr; ppp; aaa ",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionDr": "10",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionHdr": "header2",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionID": "af-afddfadsf",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionSts": "dasdff",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionTxt": "text6"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; "SectionCs": "",&nbsp; &nbsp; &nbsp; &nbsp; "SectionDr": "20",&nbsp; &nbsp; &nbsp; &nbsp; "SectionHdr": "Sec3",&nbsp; &nbsp; &nbsp; &nbsp; "SectionID": "wefwe-1001",&nbsp; &nbsp; &nbsp; &nbsp; "SectionRe": "y"&nbsp; &nbsp; },&nbsp;&nbsp;&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; "Questionnaire": [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAIs": "vvv; ooo",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionAf": "rrrr; ppp; aaa ",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionDr": "10",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionHdr": "header1",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionID": "af-afddfadsf",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionSts": "dasdff",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "QuestionTxt": "text7"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; "SectionCs": "",&nbsp; &nbsp; &nbsp; &nbsp; "SectionDr": "20",&nbsp; &nbsp; &nbsp; &nbsp; "SectionHdr": "Sec4",&nbsp; &nbsp; &nbsp; &nbsp; "SectionID": "wefwe-1001",&nbsp; &nbsp; &nbsp; &nbsp; "SectionRe": "y"&nbsp; &nbsp; }]Output&nbsp;1. Sec1 :header1 :- text1header2 :- text2- text2.1header3 :- text3header4 :- text4SectionRe : N2. Sec2 :header1 :- text6header2 :- text7SectionRe : y3. Sec3 :header1 :- text8SectionRe : y

lp280388 · Answer

Hi Team, Please help on the above request.

lp280388 · Answer

Hi Team, Please help on the above request.

Forum Discussion

Extract Text after each iteration

2 Replies

Related content

Extract Data from sharepoint

Replacing values with Iterations

iterator

Data Extraction from Oracle

Extracting data from External API