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 me also how to extract data column also
How about this expression
System.Text.RegularExpressions.Regex.Matches(YourString,"(?<=\d{2}\W\S{3}\s\d{4})\s*[A-Za-z].*(?=\s.*\W\d{2}\s.*\d{2}:\d{2}:\d{2})")
Check out this XAML file
Regex1.xaml (9.8 KB)
Regards
Gokul
Gud its working now pls tell me about to take whole date column
Try with this expression to take date
System.Text.RegularExpressions.Regex.Matches(YourString,"\b\d{2}\W\S{3}\s\d{4}\b")
Regards
Gokul
working pls explain me this exp
You can check all the details in this link : https://regex101.com/
Quick Reference and enter the expression one by one
Pls give the the exps of debit amount credit amount and time stamp
For this you can create the new topic and close this topic by mark as solved @Kuldeep_Pandey
ok doing
Thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.