Simple data cleaning

[Anonymous]

Hi,

I have a column that contains data with '(number)' after it - I want to delete the '(number)' to clean it up otherwise I'm getting unique fields for every row!

See example:

So from the above all i want to convert both of those to read 'Concomitant Medications'.

I'm sure it's straight forward but haven't been able to work it out...

Best,

Soph

[Greg_Deckler · Accepted solution]

@Anonymous Perhaps you can do a split on " ("  and then just blast the second column created?

[AlexisOlson]

Or Transform > Extract > Text Before Delimiter (using the same delimiter) to avoid the extra column.