export to text file with char(13)

[chaoma]

Hello,

I need to export this table to a text file. Here is how the table was created:

Select row_id+
column1+
column2+
char(13)+
row_id+
column3
from my table

With Char(13), it should split the data into 2 rows per record. However, after I export the table using DTS, it showed only one long row per record. What am I doing wrong? Was using Char(13) incorrect?

Note that row_id showed twice.

Thanks.

 

[mutley1]

What column does the char 13 refer to? In that code, you are getting one long string for each row because you have + as opposed to ,

What you could do is something like the below, but only as a rough guide (using substrings)

select rownum, col2, substring (text, 1, 13)
from ml
union
select rownum, col2, substring (text, 14, 255)
from ml
order by rownum

replace the table name, field names etc. ant where I have the field "text" in brackets, change that to the one you are trying to split.

 

[chaoma]

Thanks.

 

[chaoma]

Mutley,

Thank you again. You have save my day. I was going to write a more complex code. First, I thought your code doesn't work, but after a while it starts to make sense.

Thanks.

 

[mutley1]

Without seeing any sample data I just took a guess. Not sure of your fields / data types etc. so was just a quick knock-up. Glad to help / at least give you a pointer.

Good Luck!!!

Cheers,

M.