How to extract the word from text lines using regex

[shailesh1920 (Shailesh)]

I want to extract the B10 or B10(a) from below text. How can i do this ?
I have tried with regex i am getting null value.

“Annual Maintenance Contracts - IT Operating expenditure (namely AMCs and repairs) - IT Operating Expenditure (namely server / storage / appliances / hardware / software / technology infrastructure related AMCs and repairs) B10.”

[sasi_poosarla (sasi p)]

@shailesh1920

System.text.RegularExpresion.regex.match(input,“[A-Za-z0-9]+$”).value

[Parvathy (PS Parvathy)]

Hi @shailesh1920

Use this regex:

[A-Z]+[0-9]+(?:\([a-zA-Z]\))?

This regex will work for both the type you required.

Hope it helps!!

[shailesh1920 (Shailesh)]

@Parvathy

[A-Z]+[\d]+|(?:\([A-Za-z]\))?

I tried your solution with below syntax but i am getting empty value

System.Text.RegularExpressions.Regex.Match(DFPText, “[A-Z]+[\d]+|(?:([A-Za-z]))?”).Value

[rlgandu (Rajyalakshmi Gandu)]

@shailesh1920

(?<=)\s)[A-Z \d]+

[Parvathy (PS Parvathy)]

It’s working fine at my end Please do check once.

Regards,

[Shiva_Nikhil]

@shailesh1920

can you check this once

try once if you face any issues let me know

[shailesh1920 (Shailesh)]

@rlgandu

(?<=)\s)[A-Z \d]+

what is the data type of match variable ?

[Parvathy (PS Parvathy)]

Hi @shailesh1920

[A-Z]+[0-9]+(?:\([a-zA-Z]\))?

The variable type is String. Use the above Regex expression.

Regards

[shailesh1920 (Shailesh)]

Getting below error…

Assign: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.

[Parvathy (PS Parvathy)]

@shailesh1920

Make sure you give the double quotes correctly and run the process. Delete the Double Quotes and give it again.

Regards,

[rlgandu (Rajyalakshmi Gandu)]

@shailesh1920

Str_Value=System.Text.RegularExpressions.Regex.Match(Input,“(?<=)\s)[A-Z \d]+”).Value

[shailesh1920 (Shailesh)]

@Parvathy Thanks for the solution.

Could you please help me to learn the creation of REGEX patterns ??