Hello All,
I finally managed to get fix for my issue, I am sure this is not the cleanest way to deal but still it solved our issue
here is the main logic
cat file | tr -d '\n' > temp1
This will remove all the \n from file and will generate new file with single line with ^M char. We already know that when ^M comes it's end of line so now we need to replace ^M with new line
sed 's/[^M]/\n/g' temp1 > file
This will fix the issue of removing ^M char from your file and will also remove any unwated new lines from your .cvs file on unix.
Now my line looks like following
Special Olympics Missouri,None,Muller+Company,MULLE001,4498,MS-80124-58-SOMO-ME-US-Special Olympics Basketball - St Louis,,Marc Hale,C1-MS-IS,,45305,2/18/2008,3/9/2008,N/A,MySpace ROS Leaderboard (728x90) ,cpm,1.45,"434,483",0,0,0%,0,"4739 Belleview Kansas City, KS 64112 United States",Net 30,Bill on Delivery - 3rd Party,jsydnor,N/A,Associated Profile,N/A,0,0,0,0,N/A,0.00%,N,February 2008 - February 2008,"248,276",360,0,0,N/A,0,0%,0,,N/A,N/A,N/A,"16 - 18, 18 - 24",N/A,8,N/A,United States,St.Louis-609,N/A,N/A,Feb-08,2/29/2008,2/1/2008,USD,2/18/2008,3/9/2008,,,,3832,0,452,100%,,,FIM,MySpace Standard Terms,0,,,N/A,N/A,N/A,N/A
Thanks to everyone on websites who helped me to get this fixed
Cheers,
H