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