Split the input string based on \n (newline character) and then assign each string to different n number of rows
![Microsoft Business Intelligence (Data Tools): Talend ETL - How to remove special characters in the string Microsoft Business Intelligence (Data Tools): Talend ETL - How to remove special characters in the string](https://2.bp.blogspot.com/-B2_CPMxeVMc/XOYTijjNWoI/AAAAAAAAIZc/4bE6ny1t3YMfhBKFBUG9dW19rXI20kgMwCLcBGAs/s1600/Talend%2B-%2BSQL%2BServer%2BData%2BTools.jpg)
Microsoft Business Intelligence (Data Tools): Talend ETL - How to remove special characters in the string
![java - Talend- How to replace string from 'MATCHING' column to 'contactFirstName' column - Stack Overflow java - Talend- How to replace string from 'MATCHING' column to 'contactFirstName' column - Stack Overflow](https://i.stack.imgur.com/7vtvc.png)
java - Talend- How to replace string from 'MATCHING' column to 'contactFirstName' column - Stack Overflow
![java - Talend- How to replace string from 'MATCHING' column to 'contactFirstName' column - Stack Overflow java - Talend- How to replace string from 'MATCHING' column to 'contactFirstName' column - Stack Overflow](https://i.stack.imgur.com/PgLMB.jpg)