Components to clean data

One Star

Components to clean data

Hello.
I am experiencing some difficulties cleaning my data. As of right now, I have partially cleaned the data. My data consist of delimiters such as space, comma. But after using a component, I realized that some data is lost due to "\n". Any idea how to clean data without losing any rows? 
Moderator

Re: Components to clean data

Hi,
You can clean up using the tMap component to remove your data. Try to use method substring(int beginIndex, int endIndex) in tMap expression.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads