Unstructured Stage - Sheet Names to skip

jerome_rajan · Post by **jerome_rajan** » Tue Jan 26, 2016 11:39 pm

Hi,

What is the syntax for specifying the "Sheet names to skip" where there are multiple sheets that need to be skipped and have spaces in their names?

rkashyap · Post by **rkashyap** » Wed Jan 27, 2016 8:09 am

Enclose the sheetnames in a single quote with semicolon delimiter.

Code: Select all

Sheet names to skip: 'Sheet 3;Sheet 5'

jerome_rajan · Post by **jerome_rajan** » Wed Jan 27, 2016 8:27 am

Thanks for the reply, rkashyap.

The semicolon delimiter didn't work. The comma delimiter worked though. Also, each sheet had to be individually enclosed in pairs of single quotes. Must have something to do with the way our environments are configured.

Code: Select all

'Sheet 3','Sheet 5'

chulett · Post by **chulett** » Wed Jan 27, 2016 8:49 am

Pretty standard way to handle 'strings with spaces in them'.

rkashyap · Post by **rkashyap** » Wed Jan 27, 2016 12:26 pm

jerome_rajan wrote:Must have something to do with the way our environments are configured.

Yes, you are right. Syntax given in previous post works ok on 9.12 (Solaris).