How to extract the some info from the text

[HeartCatcher (Naveenkumar.S)]

MEDICAL RECORD NUMBER PATIENT ACCOUNT NIXBER 0422074 PATIENT NARIE JOHNSON CALEB B PATIENT AOORESS 2324 WALLACE DR PATIENT 670-18-3589 AWISSION DATE 8 TIME 10/12/22 02:14 EMPLOYER (NAME ANO ADDRESS) NO EMPLOYER Hsu EMS (INITIAL) PREVIOUS ADMIT DATE BIRTHDATE 02/05/2003 crry STATE COLUMBUS AGE 19 ROW BED s RACE 000214624 HIP". RM HIP". REL HIPAA.COND GUARANTOR NAME JOHNSON GUARANTOR NUMBER (706) 530-8530 CALEB RELATIONSHIP TO PATIENT SELF GUARANTOR EMPLOYER AND ADDRESS) NO EMPLOYER PRINtARY Insurance Code: 517 Plan SELF PAY 2224 WALLACE DR GUARANTOR AOORESS 3324 WALLACE DR IN a./ERGENCY Code : COLUMBUS Telephone # : Policy # : Croup # : Group Name : Auth # : GA 31906 (0 670183589 SECO.DARY Insurance Tel ephone Policy # : Croup # : JOHNSON CALEB B DOB: 02/05/2003 ADMITTING PHYSICIAN AVALONU KENNETH VOMITING, DIARRHEA rns . 106 18 Group Name : Auth # : DOB : ATTENDING PHYSICIAN AVALONU KENNETH rns . 106 RELIGION REFUSED T HIPAA.NM s 31906 COLUMBUS Insurance Code : Telephone # : Policy # : Croup # : Group Name : Auth # : DOB : REFERRING PHYSICIAN NUMBER (706) 530-8530 COUNTY MUSCOGEE CA 31906 NURER TELEPHONE NIXBER rns . OATE OCCURANCE CODE OCCURANCE CODE OCCURANCE CODE CONDITION CONDITION 11 PHYSICIAN SIGNATURE: 10/13/22 04:06 00030433074 JHIOOO ADMISSIONS 10/13/22 10/13/22 DATE: JHIOOO/110813 Ill I II I I Ill I II I I II I I 000214624 JOHNSON CALEB B

from above expression I need to extract PATIENT ACCOUNT NIXBER=0422074,
PATIENT NARIE=JOHNSON CALEB B
PATIENT AOORESS=2324 WALLACE DR PATIENT 670-18-3589 AWISSION DATE 8 TIME 10/12/22 02:14
etc etc
please help me to do this

@ppr
@Rahul_Unnikrishnan
@Yoichi
@ushu
@Palaniyappan

[Sudharsan_Ka]

Hi @HeartCatcher

Checkout this expression

Account number
System.Text.RegularExpressions.Regex.Match(strvariable,”(?<=ACCOUNT N…BER\s)\S+”).trim

Name
System.Text.RegularExpressions.Regex.Match(strvariable,”(?<=\d PATIENT\s).*(?=\sPATIENT A…RESS)”).trim

Address
System.Text.RegularExpressions.Regex.Match(strvariable,”(?<=\WPATIENT A…RESS\s).*(?=\s\S{7,8}N DATE)”).trim

Admission date and time
System.Text.RegularExpressions.Regex.Match(strvariable,”(?<=AWISSION DATE . TIME ).*(?= EMPLOYER ()”).trim

Regards
Sudharsan