Hi team, I want to extract only the values inside the () for the below records in a datatable - Spend_Category Social (SZ01428) Remit (CC01438) Local (MCZ134438) Vibrant (LC0134248) Currently I am using a regex expression - System.Text.RegularExpressions.Regex.Match(FCR_DT1(0)(“Spend…

[image] gokul1904: Social (SZ01428) Remit (CC01438) Local (MCZ134438) Vibrant (LC0134248) [grafik] (?<=\().*?(?=\))

To extract substring with Regex

Gangadhar_Athili (Gangadhar Athili) September 5, 2022, 2:41am 3

Str=Regex.Match(Str_variable,“((.*?))”).Group(1).Value

Topic		Replies	Views
Get a substring from a string Help datatable , excel , activities , string	4	1516	May 11, 2020
How to extract all regex matches splitted by Groups to a datatable Studio	8	1524	August 18, 2020
Need help in splitting a string Studio datatable , studio , question , activities_panel , text , substring	12	971	July 21, 2022
Extract and convert strings Studio datatable , excel , studio , question , activities_panel	6	1148	June 24, 2022
How to extract a value between a dynamic variable and a fixed string? Studio datatable , activities , studio , regex , string , question , string-manipulation , regex-extractor	6	479	September 30, 2023