It removed double quote from file content

[satishetc4288]

i am seeing the uploaded file content has changed . It has removed double quotes (") from the file content.
I also tried giving options like
.option("quote", """)
.option("escape", "\")

but still not resolving the issue

[shaikmanu797]

Hi @satishetc4288, could you provide me more information to replicate the issue?

The entire DFRead / DFWrite statement you tried and a fake dataset sample related to your use case.

[satishetc4288]

@shaikmanu797 here you go
Sample Data:
"6","946372","Retail, Industry","03/21/21"
"6","947113","Retail","03/06/21"
"6","947187","Retail","03/05/21"

val df = spark.read.format("csv").
option("header", "false").
load(sourceFilePath)

df.coalesce(1)
.write
.mode("append")
.option("host", config.getString("sftpHost"))
.option("port", config.getString("sftpPort"))
.option("username", config.getString("sftpUsername"))
.option("password", config.getString("sftpPassword"))
.option("fileFormat", inputFileType)
.option("uploadFilePrefix", "sample")
.sftp(config.getString("sftpTargetPath") + "/" + fileName)