I have a tab delimited text file. When I open the file with vi editor, I can see ^M character (in blue color). This is not part of my data. It got there because the original SQL data had carriage return /r sign.
713498 29195 NWSO NE SA COLLEGE 2 O- 0.3 0.3 0.0 1 MHR N Y Y ^M aher
How do I remove this character without affeting the tab locations? In other words there should be 2 tabs between the last Y and "aher" word.