OLED query with Spaces
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-09-21 02:44 PM
Hello,
I am facing an issue. I would like to get data from excel sheet, but this sheet has a space in the name.
Already tried
Have any of you had the same problem, or you know how to solve it?

Query from the picture:
I am facing an issue. I would like to get data from excel sheet, but this sheet has a space in the name.
Already tried
['POD $']
,[POD $]
and [""POD $""]
.Have any of you had the same problem, or you know how to solve it?
Query from the picture:
"select * from ['POD $']"
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-09-21 05:02 PM
@DamianDabrowski,
Are you trying to use the brackets as a BP data item replacement? Is the name of the sheet just "POS $"? If so, have you tried "select * from 'POD $'"?
Cheers,
Eric
Are you trying to use the brackets as a BP data item replacement? Is the name of the sheet just "POS $"? If so, have you tried "select * from 'POD $'"?
Cheers,
Eric
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-09-21 01:33 PM
If the file name is POD $ this will work --> "select * from 'POD $'"
If its a data item which you are passing --> "select * from '" &[POD $]&"'"
If its a data item which you are passing --> "select * from '" &[POD $]&"'"
------------------------------
Vipul Tiwari
Senior Process Simplification Developer
Amazon
------------------------------
