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?
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
