DSXchange

Hi
In the transformer i'm replacing the New Line with "
" but in the
dataset i'm seeing the output as just "&", is there anyway to get the value as it is

Input
-------
value1( New Line)
value2

present output
-----------------
value&value2

expected output
--------------------
value
value2

i'm using the syntax

Convert(Char(10),"
",lk_orac.line1)

any help is appreciated

FYI- this output is finally going to an XML output stage

thanks
MJ

The convert function will convert from a list of characters to a list of corresponding characters, one character at a time, rather than from one character to a string of many.

For that you'd need the parallel version of EReplace, posted here as pxEReplace by (most recently) the user PhilHibbs. However, I seem to recall it being... leaky.

There's an official IBM version but from what I recall, you'd have to upgrade into the 9.x world to get it.

Field(value1,'new line',1):'
'
extract the string before the new line using field function and then concatenate with the desired string.