SetOutputEscapeDoubleQuote
SetOutputEscapeDoubleQuote allows you to escape double quotes that appear in element names or data values when exporting a cube view to a .csv file.
This function is valid in TM1® TurboIntegrator processes only.
When SetOutputEscapeDoubleQuote is included in your TurboIntegrator script and set to 1, the exported file retains the double quote positions as they appear in your source cube view by escaping each double quote within another pair of double quotes. For example, if an element in your source view is named "Region", the element is exported as """Region""" in the .csv output file.
When SetOutputEscapeDoubleQuote is not included in your TurboIntegrator script or is set to 0, the exported file does not escape any double quotes that appear in your source cube.
SetOutputEscapeDoubleQuote is used in conjunction with the ASCIIOutput function, which is the function that actually writes the output file. SetOutputEscapeDoubleQuote should precede ASCIIOutput in your TurboIntegrator script, and both functions should use the same FileName parameter value.
Syntax
SetOutputEscapeDoubleQuote(FileName, Num);|
Argument |
Description |
|---|---|
|
FileName |
A full path to the file to which you want to write the cube view. Path must include a file extension. |
|
Num |
A flag that determines if double quotes are escaped in the output file. 1 indicates that double quotes will be escaped in the output file. 0 indicates that double quotes will not be escaped in the output file. |
Example
SetOutputEscapeDoubleQuote('C:\temp\cube1.csv', 1);This example escapes any double quotes encountered in the source cube view when writing output to the C:\temp\cube1.csv file.