All Forums Database
Angellore 19 posts Joined 06/10
30 Apr 2012
Tab and new line symbols

Hi all,

How can I add Tab and new line symbol to a string without using UDF?

 

Thanks.
 

ulrich 816 posts Joined 09/09
30 Apr 2012

Tab and new line are only charcters. So you can concat them as other chars...

 

select ' '!! 'text' !! '
' !! 'new line text';

 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Angellore 19 posts Joined 06/10
01 May 2012

Thanks, but I was asking about following:

Select '$' || x'0A' || '$';

ulrich 816 posts Joined 09/09
02 May 2012

So I gues you need to be more specific on your question

How can I add Tab and new line symbol to a string without using UDF?

The answer is concat.

What is the ascii number for LF and TAB?

The answer is '0A' and '09'

or for unicode 

'000A' and '0009'

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.