Hi Experts,
I have data coming in 4 columns and there are new line characters \n in between the data. I need to remove the new line characters in the middle of the row and keep the \n character at the end of the line.
File is comma (,) seperated.
Eg:
ID,Client ,SNo,Rank
37,Airtel \n Private \n limited,100,999\n
38,Vodaphone India \n Private Limited,200,888\n
39,Dell Limited,300,777\n
40,HP India Ltd\n,400,666\n
Delete red colour new line characters
Output should be :
ID,Client ,SNo,Rank
37,Airtel Private limited,100,999\n
38,Vodaphone India Private Limited,200,888\n
39,Dell Limited,300,777\n
40,HP India Ltd,400,666\n
Here my requirement is , don't delete the \n when it comes after every 3rd comma and delete new line character (\n) in between.
Pl provide the solution to achive this.
Regards
Kari