I have a python script that outputs file with similar text: This data is split by “” and is imported to a table in hive database. My issue that some of that data contains ^M carriage return character which splits up my data: I need to remove ^M and have my data all together. I have tried dos2unix on the