title: Azure Data Factory removing spaces from column names of csv file
body: <p>I'm a bit new to azure data factory so apologies if I'm missing anything obvious.  I've done several searches and I can't find anything that quite fits.</p>
  <p>So the situation is that we have an existing pipeline that will take the path to a csv file and pass this in as a delimited data set.  As a sink it is using a parquet data set.  This is a generic process that we can pass any delimited file into and it will output it as parquet.</p>
  <p>This has been working well but now we have started receiving files with spaces and special characters in the header which causes the output to parquet to fail.  Unfortunately we don't have control over the format of the files we receive so I can't handle this at source.</p>
  <p>What I would like to do is on ingestion of the file replace any spaces and other special characters in the header with an underscore.  If I were doing this on premise I could quickly create a powershell script to do it.  I had thought about creating a custom task in AFD to call a powershell script to do this in the blob storage but that seems more complicated than it should be.  Is there something else I can do to get this process working while keeping it generic?</p>