Featured Post

Applying Email Validation to a JavaFX TextField Using Binding

This example uses the same controller as in a previous post but adds a use case to support email validation.  A Commons Validator object is ...

Sunday, December 19, 2010

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.

No comments:

Post a Comment