File Names with Spaces

In Data Integrator, you may need to surround file names containing spaces with quotes. If you're doing string manipulations, you'll need to use a single quote so that there is no interference with the double quote.

For example,

imp.ConnectString = "Database=" & xlsFile & _
";Table=Sheet1;Encoding=OEM;HeaderRecordRow=1"


Is a line from a RIFL script that concatenates a Process Variable to a formatted ConnectString.

This post is replicated from  http://my.opera.com/walkerca/blog/2010/12/18/file-names-with-spaces.