Suppose there is string = 'Hello how are you? Are you there?'
I want the string to be splitted into 2 lines, basically want to put a new line character in between, so that the export file (from bteq) captures it.
o/p in export file expected:
Hello
how are you? Are you there?
None of the below solutions could generate the expected output.
.EXPORT FILE=xyz.txt;
sel 'Hello \n how are you? Are you there?' sel 'hello Chr(10) how are you? Are you there?'
Any suggestions? Can anyone help with a way to print a newline into the export file?