Please find the below screen shot of sample text file which am using to Import.
Each source field is separated using tab. For Note History field I have added special character ($*@*$). My requirement is to replace this special character with new line (\n) while importing.
But this special character is not replacing with new line.
Below screen shot shows that the special character was not replaced by new line.
Can anyone suggest a method to add new line while importing.
Any suggestion is appreciated.