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?
Unstructured Stage - Sheet Names to skip
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Unstructured Stage - Sheet Names to skip
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Enclose the sheetnames in a single quote with semicolon delimiter.
Code: Select all
Sheet names to skip: 'Sheet 3;Sheet 5'
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
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.
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'
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.