String manipulation using split function

[Yoichi]

Hi,

It’s necessary to add backslash to your pattern and add columnanme to your CurrentRow variable as the following

System.Text.RegularExpressions.Regex.Match(CurrentRow("ColumnName").ToString(),"\(.*?\)").Value 

Regards,

[THIRU_NANI (NaNi)]

Reference:

Regards,
NaNi

[RAKESH_KUMAR_Tiwari]

it gives me values also and null values also, why?, also i want distinct value.

[THIRU_NANI (NaNi)]

Hey!

Did you check the value in CurrentRow(“Responsible User”).ToString.Trim in the immediate panel?

If we are getting the value in immediate panel we can get the value n braces.

an you please check in this way?

Regards,
NaNi

[adiijaiin (Aditya Jain)]

Hi @RAKESH_KUMAR_Tiwari

Please try this expression:

CurrentRow(“Responsible user”).ToString.Trim.Split({“(”},StringSplitOptions.None)(1).TrimEnd
(“)”.ToCharArray)

It might be able to extract the data that you want.

Regards,
Aditya