Page 1 of 1
Delimiter for ASCIIOutput
Posted: Fri Jul 15, 2011 10:33 am
by 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,
Re: Delimiter for ASCIIOutput
Posted: Fri Jul 15, 2011 10:54 am
by Alan Kirk
mce wrote: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.