Using macro variable in pipe

JacquesR — Tue, 26 May 2020 08:22:59 GMT

I am just not getting something that should be obvious, so forgive my ignorance.

I have looked:

One would think that after that, I would have the solution, but no matter which combination I try, I'm not getting the right result:

So I want to replace this:

FILENAME _FList PIPE 'dir "c:\Users\...\Study-data\Posts from 20* to 2020-*.XLSX" /b ';

with this:

%LET DataDir=c:\Users\...\Study-data\;
FILENAME _FList1 PIPE 'dir &DataDir.Posts from 20* to 2020-*.XLSX /b';

But no matter how I try to quote it, I am missing what I am sure is a pretty obvious solution.

Thanks in advance

Re: Using macro variable in pipe

Kurt_Bremser — Tue, 26 May 2020 08:32:01 GMT

This is probably macro mistake #1 for macro newbies 🙂 Been there, done that 😉

Whenever you want macro variables to resolve in a string, use double quotes instead of single quotes.

yabwon — Tue, 26 May 2020 11:38:33 GMT

%LET DataDir=c:\Users\...\Study-data\;
FILENAME _FList1 PIPE "dir ""&DataDir.Posts from 20* to 2020-*.XLSX"" /b";