Apologies if it sounds a stupid question. I need to do data cleaning as below
|Original Data||Transformed Data expected|
|MAY 1000394||MAY1000394(remove spaces and convert to UpperCase)|
|MAY 73-4506||MAY73-4506(remove spaces and convert to UpperCase)|
|MAY v 1915||MAYV1915(remove spaces and convert to UpperCase)|
|MAY-P8181||MAYP8181(and convert to UpperCase, also remove '-' after MAY)|
please help out with a solution
Solved! Go to Solution.
@muralam - is this the complete data set or these are few samples. The reason to know if the data & the "-" are in fixed positions, or variable.
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.