I want to extract column data by the regex exp

DATE DESCRIPTION DEBIT AMT CREDIT AMT TIME STAMP
11.AUG 2022 SWEEP TRANSACTION 29,311,364.29 05:52:53

                              TRANSFER FROM 0340897048

                              SMR AUTOMOTIVE SYSTEMS

                              IND LTD

                              TRN REF NO:D03ZLQM22223000W

     11.AUG 2022              SWEEP TRANSACTION                                                                                                                                                136,523,922.99                23:59:59

                              TRANSFER FROM 0340897013

                              SMR AUTOMOTIVE SYSTEMS

                              IND LTD

                              TRN REF NO:D03ZLQM2222300I1

     11.AUG 2022              SWEEP TRANSACTION                                                                                                                                                243,331,538.10                23:59:59

                              TRANSFER FROM 0340897021

                              SMR AUTOMOTIVE SYSTEMS

                              IND LTD

                              TRN REF NO:D03ZLQM2222300I3

     11.AUG 2022              EFT OUTGOING                                                                                                                    -5,425.52                                                      05:59:22

                              71025683NEFT OUT UTR

                              CITIN22319610623 TRF TO

                              INDICA INDUSTRIES PVT

                              LTD. 7102568320

                              TRN REF NO:D03ZOAC2222302E0

     11.AUG 2022              EFT OUTGOING                                                                                                                   -35,655.96                                                      05:59:55

                              71025679NEFT OUT UTR

                              CITIN22319616300 TRF TO

                              INDUSTRIAL PRODUCTS

                              MFC.CO 7102567920

                              TRN REF NO:D03ZOAC2222302mt

pls tell the column of debit credit and time stamp how to get this

Hi @Kuldeep_Pandey

Check out this expression to get Date

System.Text.RegularExpressions.Regex.Matches(YourString,"\b\d{2}:\d{2}:\d{2}\b")

This expression will get the Debit and credit AMT

System.Text.RegularExpressions.Regex.Matches(YourString,"\d*[,].*(?=\s\d.\W\d.\W\d.)")
System.Text.RegularExpressions.Regex.Matches(YourString,"\W\d*[,].*(?=\s\d.\W\d.\W\d.)")

Regards
Gokul

And time stamp

Check out this Time stamp @Kuldeep_Pandey