How to extract the data using REGEXs

[copy_writes (chethan)]

Hi Team,

I need to extract the data from the paragraph the data is look like this below.

The details that you send to the (“Business”). Subject is not added please send details (“Customer”) and this was the wrong information.

hear I need to extract the details in between (“Business”) and (“Customer”) in the above example I highlighted.

Please let me know if you have any solutions

Thanks
Chethan

[supermanPunch (Arpan)]

@copy_writes

The details that you send to the (“Business”). Subject is not added please send details (“Customer”) and this was the wrong information.

Hi @copy_writes ,

Could you check with the regex expression below :

(?<=\("Business"\)).*(?=\("Customer"\))

[Gokul001 (Gokul Balaji)]

Hi @copy_writes

How about this Regular expression?

System.Text.RegularExpressions.Regex.Match(YourString,"(?s)(?<=\(“Business”\).\s)(.*?)(?=\s\(“Customer”\))").Tostring

Regards
Gokul

[copy_writes (chethan)]

Thanks for quick response I tried its not work

This Details Professional Services Statement of Work (“SOW”) is made between e International Unlimited Company (“Business”) and WestJet, an Alberta Partnership (“Customer”). This SOW authorizes details to provide Customer with Consulting Services that are subject

[Gokul001 (Gokul Balaji)]

Hi @copy_writes

Try with this pattern

(?s)(?<=\(“Business”\)\s)(.*?)(?=\s\(“Customer”\))

Regards
Gokul

[copy_writes (chethan)]

@Gokul001

(?s)(?<=\(“Business”\)\s)(.*?)(?=\s\(“Customer”\))

Yes this work can you please explain what was the (?s) means

and thanks for the solution

[Gokul001 (Gokul Balaji)]

HI @copy_writes

@copy_writes

e (?s) means

I’m not sure about this but this pattern is : Match the remainder of the pattern of the following