How to find first substring which contains any alphabet

Help Activities
, , , ,
1

Hi,
I want to find first substring which contains any alphabet and length should be more than 5.
‘Transaction’ is fixed can be used as delimiter.
Input:
“Find Transaction -/657904 SBIBANKLTD MUMBAI”

Output-
SBIBANKLTD
Input:
"Find Transaction - IDBIBANKLTD KANPUR’
Output:
IDBIBANKLTD

2

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(yourString,"\b[A-Z]{5,}").Value

Regards,

2 Likes
3

slite change on the code.
System.Text.RegularExpressions.Regex.Match(yourString,"\b[A-Z]{10}").Value
for the perfect solution.

@Mansi_Mhatre , Mark solution @Yoichi .

4

solution_Pickup_Current_value

for your understanding.

Cheers & Happy Automation

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.