How to cut off cell's text with specific mark? such as "("

[hoseongwon (호성 원)]

Hello.

I want to change cell’s text with activity “for each”

apple(fruit)
rice(grain)
banana(fruit)
steak(meat)
…

there is a column like that.
I want to get text without text in “()”
only apple, rice, banan, steak…

How can I get the values?

[aldihaissy (saald)]

Hello hoseongwon,

You can try to do it with Regex and take everything until “(” should look like this:

^[^\(]+

[Anil_G (Anil Gorthi)]

@hoseongwon

Inside the for each row in datatable/for eqch row in excel activity…use a assign activity as below

Currentrow("columnname") = Currentrow("columnname").ToString.Split({"("},StringSplitOptions.None)(0)

If use for each excel instead use currentrow.Field("Name")

Hope this helps

Cheers

[supermanPunch (Arpan)]

@hoseongwon

apple(fruit)

Hi @hoseongwon ,

You could also try with Regex Replace :

Regex.Replace("apple(fruit)","\(.*?\)","")

[Manish540 (Manish Shettigar)]

@hoseongwon

banana(fruit)

Hi @hoseongwon ,

Check this below code,
strVar(String type) = System.Text.RegularExpressions.Regex.Match("banana(fruit)",".*(?=\()", System.Text.RegularExpressions.RegexOptions.Multiline).Value

Screenshot:

Hope this help might you

[hoseongwon (호성 원)]

@Anil_G

({“(”},StringSplitOptions.None)(0)

Thank you! it really works.

I chose your answer because the most simple.