Hi All,

There is a CSV with a column ID (format: 8-digits & "D" at the end).

When trying to read a csv with .option("inferSchema", "true"), it returns the ID as double and trim the "D". Is there any idea (apart from inferSchema=False) to get correct result? Thanks for help!

Below options was tried and also failed.

options(delimiter=",", sep = ",", header=True, inferSchema=True,multiline=True, quote="\"", escape="\"")