cancel
Showing results for 
Search instead for 
Did you mean: 

OLED query with Spaces

DamianDabrowski
Level 2
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 ['POD $'] ,[POD $] and [""POD $""].

Have any of you had the same problem, or you know how to solve it?
34973.png
Query from the picture: "select * from ['POD $']"
2 REPLIES 2

ewilson
Staff
Staff
@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​

EVIPUTI
MVP
If the file name is POD $ this will work --> "select * from 'POD $'"
If its a data item which you are passing --> "select * from '" &[POD $]&"'"
------------------------------ Vipul Tiwari Senior Process Simplification Developer Amazon ------------------------------