Example of removing blanks in columnNames

ColumnFixesSpec.groovy

import spock.lang.Specification

class ColumnFixesSpec extends Specification {

    def csvData = """Name,Last Name,Age
Leonard,Gram,33"""

  def "Removing all blanks from columnNames to make them easier to parse"() {
      setup:
      def columnNames = CsvParser.parseCsv(csvData).next().columns.collect { it.key.toString().replaceAll(' ','') }

      def csv = CsvParser.parseCsv(csvData, columnNames:columnNames)
      def line = csv.next()

      expect:
      line.Name == 'Leonard'
      line.LastName == 'Gram'
      line.Age == '33'
  }
    
}