You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a way to escape a double quote in a PBCS data export rule?

Accepted answer
71
Views
6
Comments

Summary:

Is there a way to escape a double quote in a PBCS data export rule?

I would like to dynamically update the data export file name with a variable, but I am getting the following error:

"A validation error was received from the Planning server. 'Error:Syntax error in DataExport command. Please provide a valid filename Rule ITC_PLAN.Labor.Data Export - Headcount'"

I suspect the issue is that when I concatenate the variable into the file name, the final output is not wrapped in double quotes:

DATAEXPORT "File" "|" @concatenate(@concatenate("/u03/lcm/Headcount_Export_", {varYears}), ".txt") "#MI";

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!