Data starts on the second line.  Is there a simple script or utility to remove the first instance of ^m on each line of data? The problem can also be rephrased as: how can every second (even) instance of ^m be removed?  Looking forward interesting (clever) responses.  Preferably in Ubuntu or similar.Raw data for the clever to cut, paste and parse:Date,From,To,Flight_Number,Airline,Distance,Duration,Seat,Seat_Type,Class,Reason,Plane,Registration,Trip,Note,From_OID,To_OID,Airline_OID,Plane_OID^M- -,JFK,OTBD,American Airlines (AA),American Airlines,6687,13:52,,,,,777^M,,,Direct,3797,2241,24^M- -,JFK,OTBD,Qatar Airways (QR),Qatar Airways,6687,13:52,,,,,77W^M,,,Direct,3797,2241,4091^MThat being said, the reason for posing this question is the unexpected ^m is causing import problems into Libre-Office Calc (spreadsheet): it cause an expected new-line.
Removing first ^M from each line of file
text processing