The operator "concatenation" is not defined

Tips
1

I’m a bit stumped on this one. I can’t seem to get a concatenation to work for versions. The versions clause itself seems to work just fine. I’ve tried so many variations to get this working, but I haven’t found a successful combination. Anyone have any tips for this one? Thanks in advance!

q: concatenation " " of versions of files whose(name of it as string as lowercase contains “tableau-setup-std-tableau” as lowercase AND version of it < “20.4.3280”) of folders of folder "C:\ProgramData\Package Cache"
E: The operator “concatenation” is not defined.

q: versions of files whose(name of it as string as lowercase contains “tableau-setup-std-tableau” as lowercase AND version of it < “20.4.3280”) of folders of folder "C:\ProgramData\Package Cache"
A: 18.3.905.0
A: 20.4.2882.0
T: 67.587 ms

q: concatenation " " of pathnames of files whose(name of it as string as lowercase contains “tableau-setup-std-tableau” as lowercase AND version of it < “20.4.3280”) of folders of folder "C:\ProgramData\Package Cache"
A: C:\ProgramData\Package Cache{0318156d-b6c3-45c2-bc5f-d7fa788a6181}\tableau-setup-std-tableau-2018-3.20.0817.1122-x64.exe C:\ProgramData\Package Cache{ec39a1bc-02eb-4386-9f52-77df30b744cf}\tableau-setup-std-tableau-2020-4.21.1217.2244-x64.exe
T: 45.544 ms

q: pathnames of files whose(name of it as string as lowercase contains “tableau-setup-std-tableau” as lowercase AND version of it < “20.4.3280”) of folders of folder "C:\ProgramData\Package Cache"
A: C:\ProgramData\Package Cache{0318156d-b6c3-45c2-bc5f-d7fa788a6181}\tableau-setup-std-tableau-2018-3.20.0817.1122-x64.exe
A: C:\ProgramData\Package Cache{ec39a1bc-02eb-4386-9f52-77df30b744cf}\tableau-setup-std-tableau-2020-4.21.1217.2244-x64.exe
T: 21.392 ms

2

Try casting version as string.

2 Likes
3

concatenation operator only works with strings & html objects. Any other types, you need to convert first to string and then concatenate. Try:

concatenation " " of (it as string) of versions of files whose(name of it as string as lowercase contains “tableau-setup-std-tableau” as lowercase AND version of it < “20.4.3280”) of folders of folder “C:\ProgramData\Package Cache”

1 Like
4

That did the trick. Thank you both.