Input changes

[Aleksandar1]

In my  input file i have something like this: Example text ( some short text) , i need to delete this short text and () throught worklflow,how can I do that?

[binuacs]

@Aleksandar1 Use the Replace() function

Replace([Field],"short text" , "")

[Aleksandar1]

But i have one problem,my input is like this

Example

Example2 (some text)

Example3 (different text)

Example4 (some random text)

Example5 (some random text)

Example6 (some random text)

Example

Example8 (some random text)

Example9 (some random text)

Example10 (some random text)

Example

Example

I need all of this text in () to remove, note in every () is different text

[binuacs]

@Aleksandar1 Would you be able to provide some sample data and expected output?

[FrederikE · Accepted solution]

Hey @Aleksandar1,

You can use RegEx to do so: 

(.*)\(.*\)

This Regex Code captures everything, until a "(" apears, everything else is excluded.