Hi @ShobhitSingh    You need to adjust the csv file   sample.csv =========   COL1|COL2|COL3|COL4 1st Data|2nd|3rd data|4th data 1st Data|2nd \\P data|3rd data|4th data "1st Data"|"2nd '\\P' data"|"3rd data"|"4th data" "1st Data"|"2nd '\\\\P' data"|"3rd data"|"4th data"   Spark Code:     spark.read.format("csv").option("header","true").option("inferSchema","true").option("delimiter","|").load("/tmp/sample.csv").show(false)   Output: +--------+--------------+----------+--------+ |COL1 |COL2 |COL3 |COL4 | +--------+--------------+----------+--------+ |1st Data|2nd |3rd data |4th data| |1st Data|2nd \\P data |3rd data |4th data| |1st Data|2nd '\P' data |3rd data |4th data| |1st Data|2nd '\\P' data|3rd data |4th data| +--------+--------------+----------+--------+ ... View more