Delimiter for ASCIIOutput

[mce]

Hi,

ASCIIOutput function uses comma as delimiter by default. Is it possible to force it to use a separate delimiter such as TAB?

Thanks in advance for responses.

Regards,

[Alan Kirk]

Hi,

ASCIIOutput function uses comma as delimiter by default. Is it possible to force it to use a separate delimiter such as TAB?

Thanks in advance for responses.

Regards,

Look in the reference guide for the DatasourceASCIIDelimiter variable. Note that if you want to set it to a tab you'll need to use the CHAR() rules function to assign it via ASCII code. (The code value is 9 if memory serves.) Also, remember that it will affect both your source and your output; you can't have a comma delimited file for input but a tab delimited one for output. If the data source is (say) a cube view rather than a text file, that won't matter.