Regex_Statement Needed

Help Robot
,
1

Hi Team I need to extract
Description Column

  1. EFT OUTGOING
    71034915NEFT OUT UTR
    CITIN23335075070 TRF TO
    BSB EDGE PRIVATE LIMITED
    7103491520
    TRN REF NO:D03ZOAC2307307mn
    2.BOOK TRANSFER
    71034886UTR
    2312984890000002 TRF TO
    MAGNA AUTOMOTIVE (I) PVT
    LTD 7103488620
    TRN REF NO:D03ZOAC2307307n8

These 2 are diffrent Transection I need 71034915 and 71034886 no as my output like
1.71034915
2.71034886
I have applied only for EFT pls help me to add Book transfer also
if(Regex.IsMatch(row(“DESCRIPTION”).ToString,“\b\d{8}(?=NEFT)”,RegexOptions.IgnoreCase),Regex.Match(row(“DESCRIPTION”).ToString,“\b\d{8}(?=NEFT)”,RegexOptions.IgnoreCase).Value.Trim,row(“Description”).ToString)

2

Hi,

How about the following?

EFT

System.Text.RegularExpressions.Regex.Match(strData,"(?<=EFT OUTGOING\s*)\d+").Value

BOOK TRANSFER

System.Text.RegularExpressions.Regex.Match(strData,"(?<=BOOK TRANSFER\s*)\d+").Value

Regards,

3

Can’t we modify my regex query ?
if(Regex.IsMatch(row(“DESCRIPTION”).ToString,“\b\d{8}(?=NEFT)”,RegexOptions.IgnoreCase),Regex.Match(row(“DESCRIPTION”).ToString,“\b\d{8}(?=NEFT)”,RegexOptions.IgnoreCase).Value.Trim,row(“Description”).ToString)

To add =NEFT OR UTR?

4

HI,

What is your expected result from the above your expression? Do you need either of matched string?

Regards,