Extract substring from string - help

Help Studio
, ,
1

Hi team ,

I want to extract HRC(integers till a space comes) from the below examples.

  1. ewqeqe - hrc12313 sfdsdf
  2. sfdohl - HRC23424 sasdg
  3. Hrc1234131241142 - dshfk
  4. hRc23842 - shr
  5. HRc12118319 - sdad

The output should be

  1. hrc12313
    2.HRC23424
    3.Hrc1234131241142
    4.hRc23842
    5.HRc12118319

Can you pleas help me to extract the above values.
Regards,
G

2

Regex can help:
Case Insensitive option activated and Anchored on HRC:
grafik

strPattern = “HRC\d+”
Single Match:
grafik

MultiMatch
grafik

3

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