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...
Anonymous Perhaps you can do a split on " (" and then just blast the second column created?
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.
