Macro doesn't resoleve in file statement csv

Accepted Solution Solved
Reply
Regular Contributor
Posts: 158
Accepted Solution

Macro doesn't resoleve in file statement csv

[ Edited ]

Hi, 

I'm trying to output a CSV file and the macro can't be resolved for some reasons it output the macro without resolving  

 

ods csvall file='R:Location\Adjudication Status Metrics_&date..csv';

 

in the destination that's the file name I got 

 

Adjudication Status Metrics_&date.csv


Accepted Solutions
Solution
2 weeks ago
Super User
Super User
Posts: 8,115

Re: Macro doesn't resoleve in Data in file statement csv

[ Edited ]

The macro processor ignores literals inside of single quote characters. Use double quote characters instead.

ods csvall file="R:Location\Adjudication Status Metrics_&date..csv";

Also did you really mean to use a relative path on the R: drive instead of an absolute path?

 

ods csvall file="R:\Location\Adjudication Status Metrics_&date..csv";

View solution in original post


All Replies
Solution
2 weeks ago
Super User
Super User
Posts: 8,115

Re: Macro doesn't resoleve in Data in file statement csv

[ Edited ]

The macro processor ignores literals inside of single quote characters. Use double quote characters instead.

ods csvall file="R:Location\Adjudication Status Metrics_&date..csv";

Also did you really mean to use a relative path on the R: drive instead of an absolute path?

 

ods csvall file="R:\Location\Adjudication Status Metrics_&date..csv";
Regular Contributor
Posts: 158

Re: Macro doesn't resoleve in Data in file statement csv

Oh. Right 

 

Thanks so much 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 79 views
  • 1 like
  • 2 in conversation