remove text in bracket

Question

How is it possible in DATAFLOW to remove the text inside a bracket including the brackets?

for example:

colName

abc (4325550)
testing (565656511)
...

result to be:

colName

abc
testing
...

thank you

Answer 1

Hi arkiboys,

Thank you for posting query in Microsoft Q&A Platform.

If space between the brackets content and normal content will be there, then you can consider using derived column transformation and use split function in it, to split based on space and then take 0 index value.

Hope this helps. Please let me know how it goes.

---

Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.