Regex word extraction

Help Studio
1

Hello All,

I want to extract CN123456 word from below sentence.
Request for Quote : CN123456 (ABC COMPANY LIMITED)
Help me to achieve this.

Thanks in advance

2

Hi @RAMESH_G

Please try the below expression!

[A-Z]{2}\d{6}

system.Text.RegularExpressions.Regex.Match(str_input,"[A-Z]{2}\d{6}").ToString

Where str_input is the inputstring.

Regards

3

Hello @RAMESH_G

Below is the Regular Expression which can extract the string you are requesting for

(?<=:\s).+(?=\s()

Output:-

image
image1108×400 21.8 KB

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

4

Hi @RAMESH_G,

Is the same pattern always? If the are any variations of the sentence from which you want to extract the text it would be good to post them here so that we would be able to provide the most reliable solution :wink:

Regards,
Kamil

5

Thank you so much your help

6

Hi @kmisko11,

input format is same but value will be different.
E.g,
1.Request for Quote : CN123456 (ABC COMPANY LIMITED)
2.Request for Quote : CN456789-1 (BCD COMPANY LIMITED)
3.Request for Quote : CN345678-1 (XYZ COMPANY LIMITED)

Please help me in these cases.

Thank you

7

Thank you so much :smile:

8

Hi @RAMESH_G

what would be required output?

Is the above as first post or different!

Regards

9

Hi @pravin_calvin ,

Output , i need as for each match cases
I want to extract CN… number.
Like below.

  1. CN123456
  2. CN456789-1
  3. CN345678-1
10

Hello @RAMESH_G

Look at the below screenshot …!!

image
image1095×395 23.9 KB

Is it the same you are loooking for?

regex101: build, test, and debug regex

(?<=:\s).+(?=\s()

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

11

Thanks @Pratik_Wavhal
Thanks @pravin_calvin
Thanks @kmisko11

It helped me.

12

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