DSXchange

Hi everybody,


I have to pass the data to unix.

"hello world" is my input
In unix it should store as hello in one line and world should store in next line

Thx,

Add a line feed (Char(15)) to your derivation to add a line break.

Hi Arnd,

Thanx for your reply.But it is placing ^o between hello and world.That means hello ^oworld.it is not displaying in new line

Char(10) is the linefeed character, try it.

its a char(10)

example :-

col1:char(10):"sam"
in unix o/p is seen like

col1<value>
sam

My misteak <sic>; the UNIX LF is CHAR(10)

Hi sudhakar,
Here is an alternative.
Ereplace(in.Source," ",Char(10))


regards
kcs

Convert() is more efficient than Ereplace() for single character substitution.

You can gain further efficiency by initializing a stage variable (call it svLF) to Char(10) and not providing a derivation for it for each row. This means that the Char(10) function is evaluated only once.

Thanks to everybody.The problem is solved.i.e char(10)