title: how to find a delimiter from a file using pyspark
body: <p>Is there any way to find delimiter and read that file using spark read.
  basically i want to read data from file using spark read </p>
  
  <p>we are expecting three types of delimiter (,  ;  |) i.e. (comma , semicolon , pipe)</p>
  
  <pre class="lang-py prettyprint-override"><code>csv_data = spark.read.load("path of file", format = "csv",header ='true').cache()
  </code></pre>