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

ppr (Peter Preuss) September 4, 2022, 10:05pm 2

grafik
(?<=\().*?(?=\))

1 Like

Forum Engagement Daily Reports

Topic		Replies	Views
Get a substring from a string Help datatable , excel , activities , string	4	1213	May 11, 2020
How to extract all regex matches splitted by Groups to a datatable Studio	8	1351	August 18, 2020
Need help in splitting a string Studio datatable , studio , question , activities_panel , text , substring	12	878	July 21, 2022
Extract and convert strings Studio datatable , excel , studio , question , activities_panel	6	962	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	313	September 30, 2023