sher
Valued Contributor II

val df = spark.read.format("csv")

.option("header",true)

.option("sep","||")

.load("file load")

display(df) 

try this