Forum Discussion
Simple data cleaning
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
Anonymous Perhaps you can do a split on " (" and then just blast the second column created?
2 Replies
Anonymous Perhaps you can do a split on " (" and then just blast the second column created?
Or Transform > Extract > Text Before Delimiter (using the same delimiter) to avoid the extra column.
