Page 1 of 1
Unstructured Stage - Sheet Names to skip
Posted: Tue Jan 26, 2016 11:39 pm
by jerome_rajan
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?
Posted: Wed Jan 27, 2016 8:09 am
by rkashyap
Enclose the sheetnames in a single quote with semicolon delimiter.
Code: Select all
Sheet names to skip: 'Sheet 3;Sheet 5'
Posted: Wed Jan 27, 2016 8:27 am
by jerome_rajan
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.
Posted: Wed Jan 27, 2016 8:49 am
by chulett
Pretty standard way to handle 'strings with spaces in them'.
Posted: Wed Jan 27, 2016 12:26 pm
by rkashyap
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).