How to Linefeed in DTW

[Former Member]

Hello,

I want to import items with DTW.

In the fields usertext I need text with linefeeds.

What character do I need to use for this?

Kind regards,

John Slaats

[Former Member · Accepted solution]

I also had this issue. I was not able to get DTW to succssefully put the carriage return and linefeed into the DB.

The way I got around it is not really a supported way, but it worked....

I basically subsituted the CR/LF as another character such as the pipe symbol, and then I was able to have a trigger replace the pipe symbol with a CR/LF after insert. I only needed do this on an Address Field so it was not a big problem, but depending on your application, it very well may be.

Hey in another unrelated DTW question, has anyone been able to get DTW working via schedueled script (xml file) with ODBC on a <i>non-trusted</i> connection?

Thanks,

Jason Walters

[Former Member]

Hi J.S.

You can add char(13)+char(10) for line break.

Ex: "Today is Friday. char(13)+char(10) Tomorrow is SAT."

Cheers,

Bill L.

[Former Member]

Sorry guys, but this doesn't work.

I will try to insert thsi with SDK.

Kind regards,

John

[Former Member]

Hi,

Please test with chr(10) or chr(13) at the end of lines.

Regards.

[Former Member]

Hi J,

Does '\r\n' help you? (I'm not sure if it will work)

Kind regards,

Rowdy

[Former Member]

Hi R,

No it doesn't.

Anyone else?

Kind regards,

John Slaats