Andy Leonard shows us how to use Biml to remove spaces from flat file column names:
This Biml declares an AstFlatFileFormatNode named ffformat and sets it to the FileFormat named “FFCM Provider Data” found the RootNode’s FileFormats collection. I next loop through each column in the ffformat AstFlatFileFormatNode object. I use Biml to generate the <Column> object, replacing the spaces with an empty string for the Name attribute. The results in Mist appear as shown below
I loved the “I had 5 minutes, so I decided to fix it with Biml” line. Both funny and true.