I'm facing weird issue, not sure why Spark is behaving like this. samplefile.txt: COL1|COL2|COL3|COL4 "1st Data"|"2nd ""\\\\P"" data"|"3rd data"|"4th data"   This is my spark code to read data: val df = spark.read.format("csv").option("header","true").option("inferSchema","true").option("delimiter","|").load("\samplefile.xtx") df.show(false) Some how it is combining 2 columns data into one. Spark Scala : 2.4 Version Any idea why spark is behaving like this. ... View more