topic OLED query with Spaces in Product Forum

OLED query with Spaces

DamianDabrowski — Mon, 13 Sep 2021 13:44:45 GMT

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?

Query from the picture: "select * from ['POD $']"

Re: OLED query with Spaces

ewilson — Mon, 13 Sep 2021 16:02:53 GMT

@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

Re: OLED query with Spaces

EVIPUTI — Sun, 26 Sep 2021 12:33:23 GMT

If the file name is POD $ this will work --> "select * from 'POD $'"
If its a data item which you are passing --> "select * from '" &[POD $]&"'"