I need second value on between strings that is in numeric like123456789 add987654321 i need second one can you help on that

[Saikrishna_Mada]

Hi Kindly Help me on that in these String "<\r\nManage UPI ID\r\no\r\nAccount No.\r\n000401203123\r\nI\r\nV 000401203123\r\n000401203120\r\nRegistered UPI ID\r\n5583037894@icici\r\n\./\r\nINDefault a/c to send payments\r\nINDefault a/c to receive payments\r\n\/\r\nSubmit\r\n/2&:ip " I need these “000401203120” number please give me the regex.

Note-Don’t Send the screenshot please Send that Regex in Reply

Thankyou

[vishal.kp (vishal)]

Hi @Saikrishna_Mada,

Try the below regular expression:

(\d+)(?=\r\nRegistered)

Regards,

[Harshith_Adyanthaya]

Hi @Saikrishna_Mada,

\d{12}

You can use this in matches activity and take the second one by using matchesOutput(1).Value

But current output seems to be 3rd or last in that string. So you can use matchesOutput(2).Value or matchesOutput(matchesOutput.count).Value

Hope it helps.

Regards,
Harshith

[Yoichi]

HI,

"000401203120” is 3rd number, right?

If you need it by index, the following will work.

System.Text.RegularExpressions.Regex.Matches(yourString,"\d+")(2).Value

Regards,

[Saikrishna_Mada]

[quote=“Yoichi, post:4, topic:532673”]
"\d+")(2).Value
[/qu
it’s working,Thank you

[Saikrishna_Mada]

Hi Yoichi,

in these String “Manage UPI ID\r\nAccount No.\r\n000401203123\r\nI\r\nV 000401203123\r\n000401203120\r\nRegistered UPI ID\r\n5583037894@icici\r\n\./\r\nINDefault a/c to send payments\r\nINDefault a/c to receive payments\r\n\/\r\nSubmit\r\n/2&:ip” need “5583037894@icici” these value please help me on that

Thankyou

[Saikrishna_Mada]

Hi vishal,

The Merged Data Manage UPI ID page is: Manage UPI ID\r\nAccount No.\r\n000401203123\r\nI\r\nV 000401203123\r\n000401203120\r\nRegistered UPI ID\r\n5583037894@icici\r\n\./\r\nINDefault a/c to send payments\r\nINDefault a/c

in these String need “5583037894@icici” these value please help me on that

Thankyou

[vishal.kp (vishal)]

Hi @Saikrishna_Mada ,

Try the below expression:

(?<=ID\r\n)(\d+@\w+)

Regards,

[Manish540 (Manish Shettigar)]

Hi @Saikrishna_Mada ,

Check this below code,
inputStr = "<\r\nManage UPI ID\r\no\r\nAccount No.\r\n000401203123\r\nI\r\nV 000401203123\r\n000401203120\r\nRegistered UPI ID\r\n5583037894@icici\r\n\./\r\nINDefault a/c to send payments\r\nINDefault a/c to receive payments\r\n\/\r\nSubmit\r\n/2&:ip "

extractedVal(String as type) = System.Text.RegularExpressions.Regex.Match(inputStr,"[0-9]{12}(?!.*[0-9]{12})", System.Text.RegularExpressions.RegexOptions.Multiline).Value

Screenshot:

Hope this helps you