topic Re: Data Cleansing in Talend Studio

Data Cleansing

muralam — Wed, 16 May 2018 14:51:26 GMT

Hi,

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

Regards,

Meena

iamabhishek — Wed, 16 May 2018 14:59:12 GMT

@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.

Anonymous — Wed, 16 May 2018 15:09:38 GMT

Here is the solution in a tMAP

Here is the code: in.originalData.trim().replace(" ","").replace("MAY-","MAY").toUpperCase()

Is that what you need?

EDIT: better do this in this way : in.originalData.trim().replace(" ","").toUpperCase().replace("MAY-","MAY")

muralam — Wed, 16 May 2018 15:58:21 GMT

Thanks for your prompt response, its working