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?
Hey @Aleksandar1,
You can use RegEx to do so:
(.*)\(.*\)
This Regex Code captures everything, until a "(" apears, everything else is excluded.
@Aleksandar1 Use the Replace() function
Replace([Field],"short text" , "")
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)
Example8 (some random text)
Example9 (some random text)
Example10 (some random text)
I need all of this text in () to remove, note in every () is different text
@Aleksandar1 Would you be able to provide some sample data and expected output?
