Carriage Return/Line Feed

[jimny]

I am interfacing with a program that returns data in a textfile. I am able to enter a query in the format of {tablename.field}^{tablename.field}|.

I am trying to automate the process using DTS but I get a prompt that it(DTS) can not find the row delimiter (|), but if I click through and select the column delimiter, it loads the fields.

I am trying to reformat the export in the form of
{tablename.field}|{tablename.field}{Cr}{LF}
so that DTS can execute the package on a schedule, assuming that the vertical bar(and its' error) as my row delimiter is the problem .

If I use this format:
{tablename.field}|{tablename.field}{Cr}{LF}
or:
{tablename.field}|{tablename.field}\n\r
I get an empty text file.

can anyone help me format this? Should I use chr(10)?
thanx,
Lost & confused

 

[JayKusch]

What type of program is initially creating the text file?

Thanks

J. Kusch

 

[jimny]

thanks for the reply but...

program is unknown

guesstimate SQL or foxPro

thanx J. Kusch

 

[Freekawaii]

I think we are doing somethign similiar. What exactly is the problem you are having?

 

[MDXer]

try char(10) or possibly char(13)

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck