Regexproblem

Help Robot
,
1

Hi team,
I have two different statement i want ref no

  1. N340222234818715TXN REF
  2. 2301060010001508 REF NO

N340222234818715 and 2301060010001508 I want this as output in regex form

2

Hi @Kuldeep_Pandey please try this,
testStr=“your values”

  1. System.Text.RegularExpressions.Regex.Match(testStr,“.+(?=TXN\s+REF)”).ToString
  2. System.Text.RegularExpressions.Regex.Match(testStr,“.+(?=\s+REF\s+NO)”).ToString
3

Hi @Kuldeep_Pandey

Checkout thois expression

System.Text.RegularExpressions.Regex.Match(InputString,"^\S+").ToString

image
image981×248 14.2 KB

4

In 1 TXN is also coming in don’t want this

5

Checkout this expression

System.Text.RegularExpressions.Regex.Match(InputString,"^\S{16}").ToString

image
image959×238 14.1 KB

6

EFT INCOMING
N340222234818715 NEFT IN
UTR CITIN22377099474
FROM ASAHI INDIA GLASS
LTD GUR
N340222234818715TXN REF
NO 30940
TRN REF NO:D01ZOAC223401Do0
is this regex statement will work in this?

7

This is what you need right ? @Kuldeep_Pandey

image
image939×444 25.6 KB

8

2nd one I need

9

Only N340222234818715 you need @Tapan_Behera1 ?

10

If yes you can try this @Kuldeep_Pandey

System.Text.RegularExpressions.Regex.Match(InputString,"^\S{16}(?=TXN)").ToString

image
image1033×448 28.5 KB

11

@Kuldeep_Pandey

Please try this

(?=N)\S{16}(?=.*REF)

System.Text.RegularExpressions.Regex.Match(InputString,"(?=N)\S{16}(?=.*REF)").ToString`

Hope this is what youa re looking for… what it check is if there is ref and the balue starts with N and 16 characters

image
image828×660 69.9 KB

Cheers

12
  1. 2301060010001508 REF NO
    is this will work for this also?
13

@Kuldeep_Pandey

A small modification fir this to work, change regex as below

(?=N|)\S{16}(?=.*REF)

image
image828×752 76.3 KB

Cheers

14

You can try this

System.Text.RegularExpressions.Regex.Match(InputString,"^\S{16}(?=TXN)|\S{16}(?=\sREF NO)").ToString

image
image942×549 31.1 KB

Hope this Helps

Regards
Sudharsan